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"})})
shaowu459 Thanks for your reply.
I am getting following errors:
Expression.Error: The name 'Custom1' wasn't recognized. Make sure it's spelled correctly.Once i replace `Custom1` with `Custom`, i get another error:
2) Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?
How were you able to apply the transformation in place on the `Column1` of each table instead of Adding a new column? Can you share your output file?
Custom1 is the previous step name,change it to the correct name in your query.