Forum Discussion
jracer007
Helper IV
Helper IVReplace text
Hello community, How can I replace the texts in column A with the texts in column C in Power Desktop?
click on edit query, and then select advanced editor, copy and paste text from advanced editor and I will add the step for you.
parry2k
Super User
Super Userdo you want to replace text in col A only when col a is blank?
jracer007No, all text
- parry2k
goto edity query->advanced editor and add following line before "in" and make sure to add comma (",") on existing last step of the query
#"Replaced Value" = Table.ReplaceValue(#"<your last query step here>",each [Col A], each [Col C],Replacer.ReplaceValue,{"Col A"})
Assuing this is the last step in your query, replace last line in query query after "in" with this
#"Replaced Value"
- jracer007
Could you send me pictures please?