Combine data from two queries based on column headers

[LP2803]

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.

[amitchandak · Accepted solution]

@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

[LP2803]

@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.