Issue with the CSV file

Question

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.

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.

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).

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

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

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

Pictures.zip

caltang · Answer

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.

DJBL · Answer

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.

Warcry · Answer

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