Multiple table join with custom function

[Anonymous]

Hello,

I'm trying to join two tables via custom function. The tables have to merge with a LeftOuter join multiple times (so a loop in the custom function is requiered).

Table one is the leading table,

For every column (except the first column "Anzahl.oo_id - Kopie") in table one a join have to be made.

In table two there will be used the column ("id") for every join.

This is how far I can get with my limited knowledge.

() =>
let
    #"Zusammenführte Abfragen" = Table.NestedJoin({"Price_Amount__unit"},#"pimcore units",{"id"},"pimcore units",JoinKind.LeftOuter),
    #"Erweiterte pimcore units" = Table.ExpandTableColumn(#"Zusammenführte Abfragen", "pimcore units", {"abbreviation"}, {"pimcore units.abbreviation"})
in
    #"Erweiterte pimcore units"

I hope someone can help me and thanks in advance.

[v-chuncz-msft · Accepted solution]

@Anonymous,

Take a good look at parameters of Table.NestedJoin.