Skip to content
+1-888-319-3663

COMMUNITY FORUM

CSV file dropping zero

Jenn asked 8 years ago

Good Morning

I have a map running will pulls a data source with some CSV files.

Problem being I have tracking numbers mapped and it is dropping my leading zeros.

Example if the tracking number is 0123 ir pulls in 123 or if it needs to be 0005899 it pulls in 5899.

How do I have the field read as a text field? My schema template file is set to CHAR.

Thanks!

Jared replied 8 years ago

In your schema configuration  make sure after changing the DataType to Char  also click in the Data Type Width and it should populate with 255 and then click ok.


If you would like to submit an answer or comment, please sign in to the eOne portal.