Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Transformed table loses column order

I have three different spreadsheets that I am combining in a Union table.  The spreadsheets share some common data, however, the column names are different and the column orders are different.  I am ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    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)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    That's got it.  learned something new.  Somebody else recommended a Union table. When I use append it brings them together nicely.

     

    Thanks