Forum Discussion
Dynamically combine tables in power query
Hi All ,
I have a need to dynamically append the table displayed in the highlighted screenshot below while ensuring that the highlighted columns are retained. Although I've successfully merged the highlighted ones, I still require the inclusion of the other two columns. Assistance with this matter would be highly appreciated.
Thanks,
Deevs
Power Query does that automatically for you
tbl1 & tbl2 will result in the common columns being used as is, and then uncommon columns slapped on at the end.
Hi creedrulz ,
Based on your description of the problem, you want to keep the columns on the left and the right table after the two tables are merged.
Please try:
These are the page effects after the merger of the two tables.
After clicking Expand in the upper right corner, select the field you want to display it.
As can be seen from the figure below, the fields on the left still exist, and the fields you want on the right also exist.
If you have other questions, please contact me at any time.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
2 Replies
- lbendlin
Super User
Power Query does that automatically for you
tbl1 & tbl2 will result in the common columns being used as is, and then uncommon columns slapped on at the end.
Hi creedrulz ,
Based on your description of the problem, you want to keep the columns on the left and the right table after the two tables are merged.
Please try:
These are the page effects after the merger of the two tables.
After clicking Expand in the upper right corner, select the field you want to display it.
As can be seen from the figure below, the fields on the left still exist, and the fields you want on the right also exist.
If you have other questions, please contact me at any time.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!