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
So there is no user friendly way to do the last step? I dont understand how to do that "Table.group(" step other than to replace values in your formula
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
Expression.Error: The name '_' wasn't recognized. Make sure it's spelled correctly
IDK why im getting this
Hard to say without seeing the code. That could be each missed in front of formula with _