I have a CSV File that has some columns who’s values are blank, I want to leave blank not null. how do I do this.
If this was SQL I’d use a case statement:
CASE WHEN condreaid IS NULL THEN ‘’
ELSE condreaid END AS ‘condreaid’
ISNULL(condreaid,’’) AS ‘condreaid’
The default tool is leaving them NULL
what is the EasyMorph method of doing this within the CSV task. the source file is a COMMA DELIMITED CSV file.
Hi Ronald and welcome to the Community!
You can use the “Modify column” action with the following expression:
if( isempty([condreaid]), '', [condreaid])
or even simpler
If all values in [condreaid] are supposed to be text, then you can use the “Convert data types” action in the “Everything to text” mode - it will replace nulls (empty values) with empty strings. The action can be a convenient way to replace nulls with empty strings in multiple columns at once.
thank you very much. This worked.
I spoke today with Matthew and he hopes to get back to me about some final items we need.