convert all columns to string

Question

using a derived column transformation, how is it possible to convert all columns to string rather than doing this one column at a time?
Thank you

Answer 1

Hi @arkiboys ,

Thanks for posting your query on Microsoft Q&A platform.

Add a column pattern and give the below in condition 'each column that matches' :
1=1

And use $$ in the column name and provide toString($$) in the expression

Please let us know if you face any issue.

Thanks