Forum Discussion
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
- edhansCommunity 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.