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

[iKiok]

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.

Any help with the correct "table[column]" reference to the other query would be appreciated

= Table.ReplaceValue(#"Renamed Columns",Replacements[original],(Replacements[replacement],Replacer.ReplaceText,{"Activity"})

[Mariusz]

Hi @iKiok 

Can you provide a data sample?

Thanks
Mariusz

[iKiok]

@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

[Mariusz]

Hi @iKiok,

is there any chance you could prepare a sample of data that preserves the logic of your data and is easy to copy and work with?

Many Thanks

Mariusz

[iKiok]

@Mariusz 

https://makiosgr-my.sharepoint.com/:x:/g/personal/ikiokpas_makios_gr/EdYzUDAZuL9Dmh3ifrvtGSEByAL5fAA...

so, Query Logs - Column Activity, normally i would run 17 steps to replace (text contains) text from Activity Column with other text.

now I have created another Table (Query - Replacements) and I would like to do the replacements with something like

= Table.ReplaceValue(#"Renamed Columns", each Replacements[original],each(Replacements[replacement],Replacer.ReplaceText,{"Activity"})

meaning that I would like to read the column from the other query and do the replacements in the Log query.

Is that possible (reading a column from another query)? 

If yes, could you please help me with the syntax?

thank you in advance