My source delimited csv file has certain columns col1,col2, col3,col4.
I want to create another CSV file from my source file with the below column ordering Col3,col1,col2,col4
Is it possible to do in data flow/copy activity?
We can change the order of columns while using copy activity as well as data flow.
Simply drag and drop columns (6 dots before every column) to appropriate position and we are done.
Update : You must tick the advanced editor in some versions or you can't see the 6 dots.