Forum Discussion
Solved
Insert parameter from column A to column B
Hi there, I have 2 columns in PowerQuery, text and CurrentValue. The value in 'text' contains {CurrentValue1}, which looks at the CurrentValue column. For the highlighted example with '40' in Cu...
Add in a 'Replace Values' step from the Transform Tab, then update the step in the formula bar to:
= Table.ReplaceValue( #"Name of your last step", "{CurrentValue1}", each _[CurrentValue], Replacer.ReplaceText, {"text"} )
And you end up with something like:Let me know if this helped!
Add in a 'Replace Values' step from the Transform Tab, then update the step in the formula bar to:
= Table.ReplaceValue(
#"Name of your last step",
"{CurrentValue1}",
each _[CurrentValue],
Replacer.ReplaceText,
{"text"}
)
And you end up with something like:
Let me know if this helped!
Thank you CatSchneider ! This worked great. Apologies for the delayed response
