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 t...
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.
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.