community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

flat file import with unicode

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

 

 

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.

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!

Labels