Forum Discussion
Solved
Power Query Nested Table Transformation
Hi, Im trying to replace null values in a nested table with the values form the outside table. Both in and out have the the columns [cta], [scta] and [sscta]. The idea is to replace any null value in...
McReplace = Table.FromRecords(Table.TransformRows(PreviousStep, each let a = [cta], b = [scta], c = [sscta] in _&[NestedTable=ModifyTable( [NestedTable] , a,b,c )]))
or
McReplace = Table.RelaceValue(PreviousStep, each ModifyTable( [NestedTable] , [cta],[scta],[sscta] ),"",(x,y,z)=>y,{"NestedTable"})
Yooooooo! That's some world class M syntax wizardry right there.
--Nate