Forum Discussion

Anonymous's avatar
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...
Need Help
  • Anonymous's avatar
    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's avatar
Anonymous
Not applicable
4 years ago

I didn't have curly brackets. 

= Table.AddColumn(Levies, "Custom", each Table.Combine({[TableFFromlisttest],[levytable]}))

once added I get

I need somehow from this nested table to get the matching Levy $ for the words in Column1