Forum Discussion
Combine data from two queries based on column headers
Hi Team,
I created this thread previosly, however, im unable to see it in my messages not visible in the forum questions as well. Hence, creating it as a new thread again. sorry for the duplication.
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.
If you notice the columns below from Query 2 should get appended with same columns in Query 1.
Column1._source.Audio.Incoming.PacketLoss
Column1._source.Video.Outgoing.PacketLossPercent
Currently, its getting appended to Column1._source.CallRate & Column1._source.deviceType respectively in Query 1.
How can I manage to get this work? Kindly help.
LP2803 , if you have the same name as the colums, You can rename and have the same name then Append can do the task easily
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
2 Replies
LP2803 , if you have the same name as the colums, You can rename and have the same name then Append can do the task easily
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
amitchandak Thanks Amit,
Yes, If the column names are same it appends the data to the appropriate columns irrespecitve of the columns position. I did a check and understood how it does.
Thanks a lot for clarifying.
