Data Output Corruption - XLS and CSV

michael_heitz

This is a recurring problem I have seen when exporting to either XLS or CSV format. The last few cells of data become corrupted in the output.

This image is from Alteryx in the Results Pane: results pane.png

This image is from Excel when I open the CSV or XLS output: csv_output.png

This is a really simple example of the issue - but I have had it occur in files with half a million rows of data or more - on one project I had 35 output files, all of which had this issue where the last cell or two would have corrupted data in the fields like this example.

I have not had this occur, to my knowledge, when writing to a Snowflake table. It seems specific to writing to XLS or CSV formats.

Any help would be appreciated.

Thanks!

Mike

csv_output.PNG

results pane.PNG

BenMoss

Definitely not come across this before.

What does your. Csv file look like if you open it in a text editor?