Set Blanks to nulls

ds_is_fun · Post by **ds_is_fun** » Thu Nov 22, 2007 8:13 pm

My target dB is SqlServer. Whats a good way to convert blank source data to nulls?

ray.wurlod · Post by **ray.wurlod** » Thu Nov 22, 2007 8:48 pm

Convert blank source to null using an If..Then..Else expression. Test whether it's blank - if so, generate null. If not, leave it alone. Might be valuable to Trim() the source before testing. Target is irrelevant, provided that the columns to receive the nulls are nullable.

aakashahuja · Post by **aakashahuja** » Thu Nov 22, 2007 11:06 pm

A modify stage might help as well.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 22, 2007 11:19 pm

How? It doesn't have a conditional expression.

aakashahuja · Post by **aakashahuja** » Thu Nov 22, 2007 11:26 pm

Oops... missed that point... apologies...