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