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