Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

flat file import with unicode

Highlighted
7 - Meteor

Hi

 

I have  a flat file with unicode characters. When I try and import I get an error message that the data cannot be converted to string. When I search the relevant help page (https://help.alteryx.com/11.5/Reference/FlatFile.htm)  it suggests that w_string is not an option to import. Am I missing something obvious here in relation to importing the file?

 

Cheers,
Matt

 

 

Highlighted
16 - Nebula
16 - Nebula

I believe it is just a limitation of the configuration UI and you can manually alter the XML of the tool (yuck) to be V_WString and then think it will work.

 

Alternatively, if you import the file as a CSV file with no delimiter (\0) - you can specify the code page as UTF8 or UTF16 in which case it will come out as V_WString as needed.  You will need to make sure the field length is long enough (defaults to 254) and then parse the file in the workflow.

Highlighted
Alteryx Partner

You can have a look into this post about code page:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Inputting-Data-in-Chinese-Japanese-and-Korea...

 

Hope it helps!

Highlighted
8 - Asteroid
  1. The workaround that edits the yxmd file doesn't work with 2018.4 release.
  2. The workaround that uses CSV format with a non-existent delimit, which I used the pipe symbol, |, works. However, this means parsing the input using Formula tools with String functions.

 

Tested on 3/3/2020.

Labels