I have a CSV file I export from my help desk software, and quite often it will re-arrange the order of the columns. When this happens, Power Query cannot find my columns, so I have to rebuild my query from scratch. Here is an example of what I mean:
- I have the following columns: Status-Company-Overtime-Priority
- When imported into PQ, the column names are Status-Company-Overtime-Priority-Status_1-Company_2-Overtime_3-Priority_4-Status_5-Company_6-Overtime_7-Priority_8
When the order changes on export, so do the _(number) for my columns.
I merge the columns into one single column, but I am wondering if there is a way to add a wildcard to my Advanced Editor for each column so PQ ignores the appended _(number) at the end of each column?
- I have the following columns: Status-Company-Overtime-Priority
- When imported into PQ, the column names are Status-Company-Overtime-Priority-Status_1-Company_2-Overtime_3-Priority_4-Status_5-Company_6-Overtime_7-Priority_8
When the order changes on export, so do the _(number) for my columns.
I merge the columns into one single column, but I am wondering if there is a way to add a wildcard to my Advanced Editor for each column so PQ ignores the appended _(number) at the end of each column?
