How do I add a semicolon only to the end of data?
Here is how the data is currently.
This is how I need it to appear on the output.
Solved! Go to Solution.
if the field is numeric you must create a new string column
using the formula
ToString([Field1]) + ';'
or if it is already string [Field1] + ';'
Use a Formula tool and do [Column]+";"
What if I have multiple columns that require this same formula?
What if I need this same formula on majority of the columns in my input data?
How can I add a semicolon to data that is set to a date and alteryx keep the date format?
You could use the transpose Columns to Rows tool use a formula to add the semi-colon to every value and the use the transpose Rows to Columns tool to put the data back into its original format. You would need to add a Record ID tool before doing the transpose so that it doesnt loose the rows by concatenating the data together.