Issue with the CSV file

[DJBL]

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.

[Warcry]

Try UTF-16

[DJBL]

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

[Warcry]

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]

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]

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.