Forum Discussion
Solved
Combine data from two queries based on column headers
Hi Team,
I have two datasets which we are getting from API calls. Both have almost similar data but columns are not in order.
For example, Query1 fetches 10 columns & Query 2 fetches 9 columns with headers below.
| Column Number | Query 1 Column Headers | Query 2 Column Headers |
| 1 | Column1._index | Column1._index |
| 2 | Column1._type | Column1._type |
| 3 | Column1._id | Column1._id |
| 4 | Column1._score | Column1._score |
| 5 | Column1._source.CallRate | Column1._source.Audio.Incoming.PacketLoss |
| 6 | Column1._source.deviceType | Column1._source.Video.Outgoing.PacketLossPercent |
| 7 | Column1._source.DaysAgo | Column1._source.Video.Incoming.MaxJitter |
| 8 | Column1._source.EncryptionType | Column1._source.videoPacketLossPercentage |
| 9 | Column1._source.Audio.Incoming.PacketLoss | Column1._source.DisconnectCauseType |
| 10 | Column1._source.Video.Outgoing.PacketLossPercent |
Now, when i try to append these two queries, the columns from query 2 are not appending to the correct columns in Query 1 as they are not in alphabetic order or any sort of order.
How can I manage to get this work? Kindly help.
LP2803 , if you can rename the column to be the same, Append will easily do that.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
1 Reply
LP2803 , if you can rename the column to be the same, Append will easily do that.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query