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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
creedrulz
Frequent Visitor

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.

 

image.png

 

Thanks,

 

Deevs

2 ACCEPTED SOLUTIONS
lbendlin
Super User
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.

View solution in original post

v-huijiey-msft
Community Support
Community Support

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.

vhuijieymsft_0-1708421029987.png

 

After clicking Expand in the upper right corner, select the field you want to display it.

vhuijieymsft_1-1708421029988.png

 

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.

vhuijieymsft_1-1708421133433.png

 

If you have other questions, please contact me at any time.

 

Best Regards,
Yang
Community Support Team

 

If 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!

View solution in original post

2 REPLIES 2
v-huijiey-msft
Community Support
Community Support

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.

vhuijieymsft_0-1708421029987.png

 

After clicking Expand in the upper right corner, select the field you want to display it.

vhuijieymsft_1-1708421029988.png

 

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.

vhuijieymsft_1-1708421133433.png

 

If you have other questions, please contact me at any time.

 

Best Regards,
Yang
Community Support Team

 

If 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!

lbendlin
Super User
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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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