Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 .
Hi @arusiva89
Let me see if I understand:
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