Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic Input Data in Chinese Characters

li_hi_ateryx
6 - Meteoroid

hi,all

When I use the tool Dynamic input to dynamically query data in Databricks, the contents of Chinese words in two fields of data are all lost. What should I do about this? Do you have any good solutions?

Designer Version:2020.4.5.12471

Correct data:

li_hi_ateryx_1-1678154378805.png

 

 

erro :

li_hi_ateryx_0-1678154218497.png

                                                                                                                    thanks!!!

 

1 REPLY 1
FrederikE
13 - Pulsar

Hey @li_hi_ateryx,

 

Not sure if this works, but you could try it.

FrederikE_1-1678183684267.png

 

 

When reading the files as a .csv type you do have the option to specify the code page. The code page determines how the characters are read, default is ISO Latin-1 which can't handle Chinese Charaters. UTF8 should work for this, but you should test it. 

 

Labels