combine columns

[adciudad]

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

[GilbertQ · Accepted solution]

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/

[v-shex-msft · Accepted solution]

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

[GilbertQ · Accepted solution]

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/