Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Column Order Changed

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

 

 

Need Help

5 Replies

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        m_dekorte
        Resident Rockstar
        3 years ago

        Hi Anonymous

         

        Can you show the M Code from the transform file?