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'm partially there using this code

= Table.AddColumn(#"Removed Other Columns", "Custom.1", each Table.SelectRows([levytable], each List.Contains(MyList,[WordinginRegs])))

However the MyList was a test List. I would like the "list' component to point to each list within the 5 to rank column