Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

transforming data

Hello,

I am importing data from different sources and in one of my file i am getting "chinese" character for the country like this : Italy - 意大利

This is my script, how can i "insert" the search and replace fonction in my Scripting.

LOAD Nom,
Prénom,
[Adresse e-mail],
Status,
Langue,
[Champ libre 1],
[Champ libre 2],
Country,
Date(Floor([Date de création])) as Date,
year([Date de création]) as year,
month([Date de création]) as month,
day([Date de création]) as day,
hour([Date de création]) as hour,
Time(Frac([Date de création])) as Time

20 Replies
Not applicable
Author

Thanks for your great help, it is great to be able to such a community