Language translation

[arusiva89]

Is that possible to convert the text from the field in to English 

Say for an ex- I have a field called "Text" which has sentences from a different languages (not a specific set of words). I need to validate whether the sentence is in English or not. If it is in English then I have to use the same sentence otherwise I need to translate the sentence into English 

[tm_burgers]

Is it always the same Sentences? or is is a open text field that can contain anything?

If it can contain anything, how will you determine which language it is in? I know that GoogleSheets has a pretty good Translate formula, but you still have to input what the source language is. 

The options in Qlik would be to use an ApplyMap() perhaps? or there are some option in this blog post here:

https://community.qlik.com/t5/Qlik-Design-Blog/Handling-Multiple-Languages/ba-p/1473518

[arusiva89]

Thanks for the reply.Text field is not static and not specific set of words(It can contain anything).I have to find out whether the sentence is in English or not and then translate .

[ArnadoSandoval]

Hi @arusiva89 

Let me see if I understand:

• English Text, do nothing and show the English text; e.g. an ApplyMap returning the field itself when no translation is found.
• Other language, use ApplyMap(); the ApplyMap table will be humongous.

You should be the humongous dictionary by creating a single column table with all values present in the Text field, export this table to Excel, and ask somebody to translate the non-English words on column-a into column-b; once all the messages had been translated in this Excel file, you load it and build the mapping table; its key column is the non-English text (column-a) its data (English message) is column-b

hth