Forum Discussion
sadafzafar
Mar 01, 2022Copper Contributor
Power Query: Translate a column for comparison
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:
| Code | Type |
| 1001 | Essential |
| 1002 | Essentiel |
| 1003 | Esencial |
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.
No RepliesBe the first to reply