Forum Discussion
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 nested table in the above picture is where the seperated values go. So for Example 167 when broken up has 1 value "TSF24" and 2 Values of "TS12BLW".
What I'm trying to figure out is how to get the "PartDescr" Column within the Nested table that matches the "PseudoLines" Value. For example for row 167's nested table:
for each value in "PartNum" search for it in the "ID" nested table column and add if found in the "PseudoLines" column, add it's "Part Description" to the nested table. Is this possible in power query?
Thanks.
NewStep=let a=Table.Buffer(Table.Distinct(PreviousStepName,"PartNum")) in Table.TransformColumns(PreviousStepName,{"NestedTableColumn",each Table.AddColumn(_,"PartDescr",each a{[PartNum=[PseudoLines]]}?[PartDescr]?)})
1 Reply
- wdx223_DanielCommunity Champion
NewStep=let a=Table.Buffer(Table.Distinct(PreviousStepName,"PartNum")) in Table.TransformColumns(PreviousStepName,{"NestedTableColumn",each Table.AddColumn(_,"PartDescr",each a{[PartNum=[PseudoLines]]}?[PartDescr]?)})