Forum Discussion
LP2803
Responsive Resident
Responsive ResidentCombine 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 column...
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
amitchandak
Super User
Super UserLP2803 , 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