Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |