Randomized columns in source CSV file

phitho

New Member
Joined
Aug 26, 2014
Messages
28
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?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,362
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top