Forum Discussion
Solved
Multiple text substitution with a Table.NestedJoin
I'm trying to substitute multiple text values with a table that contains substitutes. On the merging step I got an error: What's wrong with the query ? The query is following: let tabl...
You are missing the column name that contains the nested join in your parameter list. It goes just before the join kind.
You are missing the column name that contains the nested join in your parameter list. It goes just before the join kind.
jointable=Table.NestedJoin(#"Sorted Rows", {"Attribute"}, tabletojoin, {"Name"},"newcolumnname",JoinKind.LeftOuter),
