This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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?
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.