Forum Discussion

iKiok's avatar
iKiok
Frequent Visitor
7 years ago

Power Query - (M code) - replace text in a column with values from a column in another query

Greetings to all,   I would like to replace many individual values in a column with values that exist in another query.   I cannot merge since I would like it to be a "text contains" replacement....
Need Help
Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi iKiok 

Can you provide a data sample?

Thanks
Mariusz

iKiok's avatar
iKiok
Frequent Visitor
7 years ago

Mariusz here is the data in 2 queries. Normally I would run 20 steps of "Replace Value", so now I am looking to make it happen a bit faster and easier

 

Column where values need to be replacedReplacements Table