Forum Discussion
From Folder Connector Converting Some data to Null
How can a CSV file have binary data? It should be pure ASCII.
You also want to make sure the file formats are actually the same. ASCII and ANSI are different, and some may have a CR/LF at the end and others a CR.
When pulling in a CSV file you can change the type it is.I'd pull a few of those in manually and see what the import preview shows. It may help in debugging then combining the files from a folder.
How can a CSV file have binary data? It should be pure ASCII.
You also want to make sure the file formats are actually the same. ASCII and ANSI are different, and some may have a CR/LF at the end and others a CR.
When pulling in a CSV file you can change the type it is.
I'd pull a few of those in manually and see what the import preview shows. It may help in debugging then combining the files from a folder.
Hi edhans,
Apologies for the confusion, I meant that the values in the problem columns are either a 0 or a 1 (I'll be sure to be more clear on this in the future).
Your recommendation for debugging worked. It turned out the sample file was in a weird format compared to the rest of the files and was causing the system to not recognize the values.
Thanks!
Great! Glad you found the issue.
