question

RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 asked MartinJaffer-MSFT answered

Reorder columns automated

Hello Team

I have csv files which are not in proper order in blob storage.The column metadata is in the model.json i will want to reorder all the csv file and place in one of the folder.

Please advise.

Regards
RK

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered

Hello @RohitKulkarni-3496 and welcome back to Microsoft Q&A.

The most straightforward way I can think to re-order the columns is using Copy Activity. Create two datasets pointing to the same blob. In the source dataset, import the existing schema. In the destination dataset, upload a custom schema with the correct column ordering.
If both schemas have all the column names, automapping should be enough to re-order the columns.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.