Combine data from two queries based on column headers

[LP2803]

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.

[amitchandak · Accepted solution]

@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