Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Leo77
Contributor
Contributor

Language

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 

Labels (3)
5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Leo77
Contributor
Contributor
Author

Thanks for this ,but i dont know how to translate the names  from french to english 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Do you want an automated translation, without having to define the translations beforehand?

-Rob

Leo77
Contributor
Contributor
Author

Yes rob ,as i dont know french and also there are many colounms all are in french 

Crichter141
Creator
Creator

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