Forum Discussion

SYM1986's avatar
SYM1986
Helper I
5 years ago
Solved

Column order in data view

Hi all， I have a report，after  i load the data soure. There are five queries，2017，2018，2019，2020, 2021. These queries have the same column order in power query.But afer i apply the querie，four of t...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    With UNION function, columns are combined by position in their respective tables.


    If you want to combine multiple queries into a query, you can also use Append queries in Power Query Editor as an alternative which are combined by column headers.

     

    Regards,
    Community Support Team _ Jing

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

With UNION function, columns are combined by position in their respective tables.


If you want to combine multiple queries into a query, you can also use Append queries in Power Query Editor as an alternative which are combined by column headers.

 

Regards,
Community Support Team _ Jing

SYM1986's avatar
SYM1986
Helper I
5 years ago

Yes v-jingzhang ，it‘s a very good solution. Thank you.