Forum Discussion
Multiple Transformations on a Column of Tables - Power Query
if i have a Column containing Tables like this: and before expanding the Tables, i want to do multiple Text Transformations (and Table transformations) on the "Column1" of each Table, which l...
Hi, Anonymous , please check if this is what you need.
you have a table, each row of the column "Custom" is a able, like below picture:
You need to do transformation of each row like:
= Table.TransformColumns(Custom1,{"Custom",each Table.ReplaceValue(_,0,0,(x,y,z)=>if Text.Contains(x," ") then "R0."&Text.Split(x," "){1} else x,{"Column1"})})
That's pretty tough. The best way to do it is to add a new table column that contains the newly transformed column:
= Table.AddColumn(#"PriorStep", "NewTable", each Table.ReplaceValue([Custom],"SomeSegment ","Ro.",Replacer.ReplaceText,{"Column1"}))
Now your column is transformed, and your tables still nested!