ReplaceValue for multiple columns

[Anonymous]

Hi guys,

I would appreciate some hints on how to solve a problem I'm currently facing. The goal is to replace values for multiple colums dynamically.

In case the Column "ACC (Lx)" is null, it should take the value from "ACC (Lx) (v)". 

For a single column I do it like this:

= Table.ReplaceValue(#"Converted to Table",null, each [#"ACC (L5) (v)"],Replacer.ReplaceValue,{"ACC (L5)"})

Any ideas on how I can make it dynamic for all columns?

Thanks

Dan

[Anonymous]

thanks @wdx223_Daniel 

[wdx223_Daniel · Accepted solution]

=Table.FromRecords(Table.TransformRows(#"Converted to Table",each let a=Record.ToTable(_) in Record.FromTable(Table.ReplaceValue(a,each [Value],each [Name],(x,y,z)=>x??a{[Name=z&" (v)"]}?[Value]?,{"Value"}))))