Power Query: Translate a column for comparison

New Contributor

Hi,

I want to translate a column to english for comparison in Power query. I dont want to make a change in the excel sheet. For example:

I have this data:

CodeType
1001Essential
1002Essentiel
1003Esencial

Here the data is in 3 languages: English, French and Spanish. I would like to convert the column "Type" in english so that I can compare this data to add various checks using a power query. I dont want to hard-code.

 

0 Replies