Forum Discussion
Column Order Changed
Hi Anonymous,
Did you use the Combine & Transform data option when set up the folder connector?
If so, there should be a "transform sample file" query. Select it and make sure to add a reorder columns step, to deal with this new column arrangement. Just drag one of the columns around - that should do it.
Ps. If this helps solve your query please mark this post as Solution, thanks!
Hi m_dekorte , thanks for your reply. I've tried to follow your guide. but I still got this
I'll explain more detail, so I must download sales file in the system to save in the folder every single day, from the beginning of the year, day by day seperately. And now with the files with new column order, the column header doesnt match with sample file before. Then comes error.
My only solution now is to manually download sales files day by day from the beginning of the year and redo the query, but it'll cost much time, and I dont know when until the system change the order column when I download the files again ðŸ˜
Hi Anonymous
Can you show the M Code from the transform file?