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

     

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago

NewStep=Table.CombineColumns(PreviousStepName,{"TableFFromlisttest","leveytable"},each Table.AddColumn(_{0},"Levy $",each _{1}{[WordinginRegs=[Column1]]}?[#"Levy $"]?),"TableFFromlisttest")