SAP Export always changes the columns' orders and leads to query breaks

[Martin sherk]

So I have a Query that its source is an SAP exported excel file, problem is that people always export that report using their layouts so exported tables had different column orders and sometimes miss some columns from one person to another so I can't make a unified query source that everyone can work on.

the query act based on only 4 columns from that exported SAP excel and am sure everyone is exporting those columns, However, how can I avoid query breaks and how can I let these people just copy and paste the exported SAP table with wtv. headers order they want without causing any breaks to my query.

 

[Automatrix]

Delete the superfluous columns using the "Remove other columns" action. As you can see in the M code, it only references the columns it actually keeps in that case. Make sure that there isn't any actions (such as Changed Type) referencing the columns-to-be-deleted before that.