Forum Discussion
Solved
Merging queries with partial common column
Greetings, I am looking for a way to make this conversion in PowerQuery Please note that the only common value is column 1 and that the quantity of values is not the same in all columns Thank...
Table.Group is generated automatically as here
After that in formula bar (or in Advanced Editor) you shall for each column remove this part
and replace each _ with formulas above
Start Merge Tables.
Step 1: Select your main table.
Step 2: Pick your lookup table.
Step 3: Select matching columns.
Step 4: Choose the columns to update in your main table.
Step 5: Pick the columns to add to your main table.
Step 6: Choose additional merging options.
Step 1: Select your main table.
Step 2: Pick your lookup table.
Step 3: Select matching columns.
Step 4: Choose the columns to update in your main table.
Step 5: Pick the columns to add to your main table.
Step 6: Choose additional merging options.
