Double source column import
By that do you mean that you change the column format from General to Text?
It isn’t clear what exactly you want this column to be.
That you said “convert source to a string” suggests that you mean text/string – but then I don’t see any reason ODBC would read the data and set it to 0 unless the field really was 0.
Best Practice from a SC/ODBC perspective that when using Excel as a source you make sure that the source file column is always set to the correct format vs “general”. You don’t want ODBC to be guessing at your data.
The folder data source doesn’t not give me an option for ODBC does it?
A folder data source will not give you the ODBC option. If you need to use an ODBC source with a Folder data source you will need to replicate a Folder data source as shown in this article.
If you would like to submit an answer or comment, please sign in to the eOne portal.