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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
adciudad
Helper II
Helper II

combine columns

Want to know how to do in the query editor to combine tables using 3 fields of each, that is, its primary key is composed of 3 fields

2 ACCEPTED SOLUTIONS
GilbertQ
Super User
Super User

Hi there

Here is a blog post by Ken Puls who explains how to do it with 2 columns, you can simply click on the 3rd column to have it across the 3 fields.

https://www.excelguru.ca/blog/2015/10/28/merge-data-based-on-two-columns/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

v-shex-msft
Community Support
Community Support

Hi @adciudad,

 

You can add a column to original tables with merged 'column1','column 2' values, then use these new columns as join key to combine two tables.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @adciudad,

 

You can add a column to original tables with merged 'column1','column 2' values, then use these new columns as join key to combine two tables.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
GilbertQ
Super User
Super User

Hi there

Here is a blog post by Ken Puls who explains how to do it with 2 columns, you can simply click on the 3rd column to have it across the 3 fields.

https://www.excelguru.ca/blog/2015/10/28/merge-data-based-on-two-columns/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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