Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data which field names are in french ,is there any possibility if i load the data into qlik it automatically translates into english
You can use the Alias statement in your script:
Alias Nom as Name, Ville as City, "Code Postal" as "Post Code";
Load * From ....;
You can list as many translations as you wish using multiple Alias statements if you like. The names need not appear in the particular file you are loading.
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Thanks for this ,but i dont know how to translate the names from french to english
Do you want an automated translation, without having to define the translations beforehand?
-Rob
Yes rob ,as i dont know french and also there are many colounms all are in french
Leo
Hello. I've asked something similar and here's what I've learned. Qlik does not offer translation for language at this time. I have seen evidence that there may be extensions for translation but I can't vouch for how good they are (and they are not free). See Qlik Branch.
https://developer.qlik.com/garden/5a14453f37c649c98bc53f02
In our case, we translate from English to German and we've had to create our own crosswalks (luckily we have a few translators to validate for us). As Rob has stated, your best solution in today's environment is to 1) Obtain a translation crosswalk from the French terms to the English terms, and 2) Load using an alias.
Best,
Cheryl