Forum Discussion
Transformed table loses column order
Anonymous
Thanks for the images. I see what you mean now.
Is there a specific reason you need all tables to show the columns in the same order?
BTW, you might consider actually appending the region tables (China EMEA, Americas) into one single table in Power Query (which will make life easier further down the road when using measures, creating visuals etc)
Can you post a depiction of the before and after? If the table-append function does not respect column integrity, it is probably because the name in one of the columns does not match the corresponding columns in other tables (a space could be the culprit). Also make sure that the data type is the same, though it shouldn't affect the appending of tables.
This image shows all 3 tables in Power Query. You can see that all three have the same headings and the same data type.
This image shows one of the tables. Top view is in Power Query. You can see the column ordering. The second view is from table view. You can see the columns have shifted.
Anonymous
Thanks for the images. I see what you mean now.
Is there a specific reason you need all tables to show the columns in the same order?
BTW, you might consider actually appending the region tables (China EMEA, Americas) into one single table in Power Query (which will make life easier further down the road when using measures, creating visuals etc)
That's got it. learned something new. Somebody else recommended a Union table. When I use append it brings them together nicely.
Thanks