Forum Discussion
Solved
Power Query | Batch Replace String
Hi, How do I replace this: Foreign Language 1 Foreign Language 2 Foreign Language 3 Foreign Language 4 Foreign Language 5 Foreign Language 6 into this in a single pass: In ...
In that case you can use this code:
= Table.TransformColumnNames(Table1, each try Translations{[Foreign = _]}[English] otherwise _)It searches each column name in the Translations table and - if found - replaces it with English; if not found then leave it as is.
Hi ovetteabejuela..
If the diferent texts are in a row first you have to select all these columns and unpivot using Unpivot Columns from Transform tab. In In this way you have only a column with the diferent texts.
Then, You just select the column and to use "1-->2 Replace Values" from Transform tab.
Tell us if this help you.
Miltinho,
Hi ovetteabejuela.
I think you are complicating some easy to do with just using a merge query.
Bye.
Miltinho