Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multiple table merge with multiple column condition

Hi,

 

I would like to merge two table but i need to look at mutile column to see if I have a match.

the goal is to find if there is a match in the column IP1 then IP2,IP3... in each of the other table IP column.

and if possible add plus one on the number of matches 

table 1:

Name | IP1 | IP2 | IP3 | IP4 | IP5

table 2:

Depatement | IP1 | IP2 | IP3 | IP4 | IP5

merge table:

Name| Depatement | IP1 | IP2 | IP3 | IP4 | IP5| Number of matches 

 

Do you have any idea now I can proceed in Power Query?

Thank you very much

  • You can merge in Power Query on multiple fields. Just CTRL-Click the 2nd-Nth fields on both tables in the same order. Little numbers will show up to show you which columns will join based on which.

     

     

1 Reply

  • edhans's avatar
    edhans
    Community Champion

    You can merge in Power Query on multiple fields. Just CTRL-Click the 2nd-Nth fields on both tables in the same order. Little numbers will show up to show you which columns will join based on which.