Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
LP2803
Responsive Resident
Responsive Resident

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 NumberQuery 1 Column HeadersQuery 2 Column Headers
1Column1._indexColumn1._index
2Column1._typeColumn1._type
3Column1._idColumn1._id
4Column1._scoreColumn1._score
5Column1._source.CallRateColumn1._source.Audio.Incoming.PacketLoss
6Column1._source.deviceTypeColumn1._source.Video.Outgoing.PacketLossPercent
7Column1._source.DaysAgoColumn1._source.Video.Incoming.MaxJitter
8Column1._source.EncryptionTypeColumn1._source.videoPacketLossPercentage
9Column1._source.Audio.Incoming.PacketLossColumn1._source.DisconnectCauseType
10Column1._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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.