Forum Discussion

serjio's avatar
serjio
New Member
9 years ago

Field's sorting in load script

I have load 4 tables from google analytics with idetntial fields.

i need to union this tables and work with union data, but field's sorting in one table is differ from other: http://joxi.ru/vAWDOn6S1kNabr

 

Why and how fix this trouble?

Need Help

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    serjio

     

    The sorting of fields is generated from the data source. You may check the Power Query for retrieving data in Advanced Editor. However, you can reorder the columns in Query Editor.

     

     

     

    As your 4 datasets have same columns, different column sorting doesn't impact if you UNION those multiple datasets via "Append Query".

     

    Regards,

    Simon Hou