Alteryx Gallery To view the work of fellow users and to publish your own workflows. All four digits of the year 2016. Check Copy Output Fields and Add and select Prefix or Suffix to create new columns for the data.
A conditional function performs an action or calculation based on a test of data using an IF statement.
Two digits are mapped to a range of the current year minus 66 to the current year plus 33. Two or four digits are read. Select Add Column and enter the new column name. The multi-row formula tool is pretty self-explanatory.