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've worked out how to get the Max from the table

= Table.AddColumn(#"Added Custom12", "Custom", each Table.Max([Custom.1],"Levy $"))

giving a record

which when expanded gives the result I'm after

 Then only issue remaining is how to point to the List within the "5 to rank" column instead of my 'test list' called "MyList" which sits externally to the table i'm in