Compare different columns in different languages

Question

Hello&nbsp;&nbsp;I have a problem comparing two different columns of country names. As the language is different for both fact tables. Fact table 1 has German and fact table 2 has English. How can I convert one to the other so that I can compare them?&nbsp;Thank you in advance 🙂

anonymous · Accepted Answer

HI&nbsp;ADDHOPE,
As&nbsp;amitchandak&nbsp;said, I think you need to add a new table(e.g. id, type, text/id, raw, translator ) to map the similar text with two different langue versions. Then you can use this to help map and analysis two different types of records.
Regards,
Xiaoxin Sheng

Forum Discussion

Related content

Different schema into different destination

Page Level filter for different groups

Difference between different Staging lakehouses

Dynamic Calculation Different Period

Date Different return wrong value