Forum Discussion
using a dynamic column name in Table.AddColumn columnGenerator
Hi, all, I would like to build on a very useful query Chriss Webb published on his blog (Using List.Generate() To Make Multiple Replacements Of Words In Text In Power Query). I would like to turn it...
Replace your output line with this
Output = Table.AddColumn(TableToChange, ColumnToMakeReplacements & " Replaced Text", each ReplacementFunction(Record.Field(_,ColumnToMakeReplacements)))
Hi Anonymous ,
I think it seems a bit difficult, because the ReplacementFunction provided in the blog also refer to the columns in the data source. So it's a bit difficult to say dynamic.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Okay, so it is not so straightforward as I originally thought. Sad to hear that.
Anyway, thank you for taking time to answer.