Forum Discussion
Bulk Replace Values in a Single step, conditionally based on other column
Hello,
I'm trying to replace New York in Column 1 with Column 2 values in a single query step. However, I'm not able to do that since in Column 1 has one-many values i.e. one New York has multiple Small and Large rows.
Is it possible to overcome this?
Thanks in advance!
Hello Dom87326 ,
I am not sure if exactly need a single step, but following may help you:
Just add a conditonal column:
Below is the link:
https://drive.google.com/drive/folders/13GqszjaxJkppmX57NZBn_T9LYIUk3YZ7?usp=sharing
4 Replies
Please add an example of your desired output given the data you have shown.
NewStep=Table.ReplaceValue(PreviousStepName,"New York",each [Column2],Replacer.ReplaceValue,{"Column1"})
Hello Dom87326 ,
I am not sure if exactly need a single step, but following may help you:
Just add a conditonal column:
Below is the link:
https://drive.google.com/drive/folders/13GqszjaxJkppmX57NZBn_T9LYIUk3YZ7?usp=sharing
