CSV truncates the zeroes from the column as the data flows from Alteryx to CSV

Question

Hi,

I was performing the data cleaning and everything was fine intil I loaded the data from the Alteryx to CSV using the Output tool.

The csv truncated the leading 0's from the zipcode.

For example : the zipcode was - 08701, but the csv shows the 8701.

Same holds true for many other zipcode values.

I tried this approach - CSV file Data->From Text/CSV

It is not working. Can you please help?

Thanks,
Radhika

clmc9601 · Answer

Hi @radhikasood1112,

I think the problem is in your csv viewer. If you are using Excel, please make sure the column is set to "text" instead of numeric.

If you want to confirm the leading zeroes exist, try opening the csv in a text editor.

radhikasood1112 · Answer

I did it. But it doesnt solve the purpose.

Thanks,

radhika

clmc9601 · Answer

If this fixed your problem, please consider marking the above post as a solution so others may find it.

Or I'm happy to help you keep troubleshooting. Happy solving!