Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

combine 2 nested tables within separate columns

I have a list "5 to rank" which I also converted to a table "TableFFromlisttest". I would like to achieve the TableFFromlisttest [Table] to have an extra column which i can then perform a Group by L...

Anonymous
4 years ago
I may have found a solution using:
= Table.AddColumn(Levies, "Custom.1", each Table.ExpandTableColumn(Table.NestedJoin([TableFFromlisttest], {"Column1"}, [levytable], {"Wording in Regs"}, "Testtable2", JoinKind.LeftOuter),"Testtable2", {"Levy $"}, {"Levy $"}))
result

Anonymous

Not applicable

4 years ago

I may have found a solution using:

= Table.AddColumn(Levies, "Custom.1", each Table.ExpandTableColumn(Table.NestedJoin([TableFFromlisttest], {"Column1"}, [levytable], {"Wording in Regs"}, "Testtable2", JoinKind.LeftOuter),"Testtable2", {"Levy $"}, {"Levy $"}))

result