We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Issue with the CSV file

DJBL
7 - Meteor

I have a CSV file and when I try to run in Alteryx using the configuration from the picture #1, I don't have the same result then picture #5 when I run the CSV within Excel.

Screenshot 1.jpg

Screenshot 5.jpg

I tried to change the Code Page using 'Unicode UTF-8' (see picture #6) but I still don't have the same result then picture#5.

Screenshot 6.jpg

Interesting point: I noticed that when I use the Code Page 'ISO 8859-1 Latin' the records displayed change every time that I run the workflow (see pics # 1, 2, 3). 

Screenshot 1.jpg

Screenshot 2.jpg

Screenshot 3.jpg

The same case using the Code Page 'Unicode UTF-8' (see pics 6, 7, 8).

Screenshot 6.jpg

Screenshot 7.jpg

Screenshot 8.jpg

Can someone help me fix this issue to get the data just like in Excel view?

 

Note: I share the picture #4 to show how Excel read the code page (File Origin) to pull out the data correctly

Screenshot 4.jpg

I can't share the CSV file because it's 1.6 GB size.

5 REPLIES 5
Warcry
9 - Comet

Try UTF-16

DJBL
7 - Meteor

I have already done it, and the same issue is still showing through UTF-16

Warcry
9 - Comet

Which csv style is the file saved as? Could you share a sample even if its just the column that is causing the issue.

DJBL
7 - Meteor

Tks Warcry for your help, I really appreciated it.

 

For this part of the project, I decided to save the CSV file as Excel file as shown the picture #5 and then take the Excel as Input file to ensure completeness and accuracy of the key information.

caltang
17 - Castor
17 - Castor

Perhaps instead of the Dynamic Input tool, you may want to consider using a Batch macro that reads your CSV the way you want it to?

 

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309 -> This for me has always worked regardless of file types.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors