Forum Discussion
Solved
Conditional replace text based on if the value is present in another column in the same row
Hi, I'm having trouble using the Table.ReplaceValue function with a condition. I want to replace the values in one field (Print), with the values in another field (REPLACE Print), but only i...
Hello! Please give this a try...
= Table.ReplaceValue(#"Previous Step Name", each [Print], each [REPLACE Print] ?? [Print], Replacer.ReplaceValue,{"Print"})This statement says exactly what you are trying to do. The other difference between it and your script is that you had the replacer function as Replacer.ReplaceText (partial value) instead of Replacer.ReplaceValue (entire value).
BEFORE:
AFTER:
Hello! Please give this a try...
= Table.ReplaceValue(#"Previous Step Name", each [Print], each [REPLACE Print] ?? [Print], Replacer.ReplaceValue,{"Print"})This statement says exactly what you are trying to do. The other difference between it and your script is that you had the replacer function as Replacer.ReplaceText (partial value) instead of Replacer.ReplaceValue (entire value).
BEFORE:
AFTER:
Hey!
This worked great, thank you
Best,
Dan
Wonderful! Please consider giving my solution a thumbs-up and marking it as an accepted solution.