Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Import data from input file

Dhilip_Kumar
8 - Asteroid

I got invalid result while import data from the input file. I have attached my input file and workflow for your reference and i got different result on first row. I do not see those punctuations on the input file file. Please do the needful.

 

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @Dhilip_Kumar 

 

I dont know for sure why this is happening. What i do know is that the flat ASCII input config has the limitation of not being able to handle VW_String, and after some tests i guess that this is somehow related with your issue.

 

So, one way to make it work is by configuring the input to .csv (.csv is able to handle VW_String) and parse the positions inside of the workflow:

 

parse.png

 

It is not exactly pretty, but it works.

Dhilip_Kumar
8 - Asteroid

Thank you so much. It works fine.

Labels