Column Order Changed

[Anonymous]

Hello everyone,

I've builded a report from a folder included daily sales files. So I'll download csv file from system and save them into that folder.

• The problem that I met is from today, the column order will be changed, like this:

So the query wont work if I load more files in the folder.

My English is not very good but I hope I express it right. Is there anyway that we can fix this? Thank you everyone

[m_dekorte]

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!

[Anonymous]

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 😭

[m_dekorte]

Hi @Anonymous

Can you show the M Code from the transform file?

[Anonymous]

this is it @m_dekorte 

[m_dekorte]

@Anonymous thanks, by the looks of it that shouldn't cause issues. 

Can you start at the top and select each step from you spe_sku_perf query, to see where the error first occurse and what the error message says.