Forum Discussion

automated_user's avatar
automated_user
Frequent Visitor
3 years ago
Solved

Looking for a value in a nested table and adding data to the nested table

Hi,  I have a table here:  This Table has a column called "ID" with nested tables in it that takes the "PseudoNo" Column and seperates the string by the "," .  The "PseudoLines" column in the...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewStep=let a=Table.Buffer(Table.Distinct(PreviousStepName,"PartNum")) in Table.TransformColumns(PreviousStepName,{"NestedTableColumn",each Table.AddColumn(_,"PartDescr",each a{[PartNum=[PseudoLines]]}?[PartDescr]?)})

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

NewStep=let a=Table.Buffer(Table.Distinct(PreviousStepName,"PartNum")) in Table.TransformColumns(PreviousStepName,{"NestedTableColumn",each Table.AddColumn(_,"PartDescr",each a{[PartNum=[PseudoLines]]}?[PartDescr]?)})