input Column 0 value to NULL in target

anudeepdasari001 · Post by **anudeepdasari001** » Wed Feb 10, 2016 3:00 pm

How to convert source Input value that is 0 to NULL in target DB

chulett · Post by **chulett** » Wed Feb 10, 2016 3:18 pm

You don't "convert" it so much as replace it with NULL and that should just be an if-the-else derivation or something similar.

anudeepdasari001 · Post by **anudeepdasari001** » Wed Feb 10, 2016 3:42 pm

That is varchar column in source and date column in target
Database-Oracle

ray.wurlod · Post by **ray.wurlod** » Wed Feb 10, 2016 4:19 pm

Makes no difference to what Craig suggested.

You'll need to convert the string to a date if it's valid, otherwise set the value to null. Do these things in a Transformer stage.

Something like:

Code: Select all

If (IsValid(InLink.TheString, "date")) Then StringToDate(InLink.TheString) Else SetNull()

skp · Post by **skp** » Wed Feb 17, 2016 3:11 am

Hi,

Use below logic.

If Trim(Input_Column)=0 Then SetNull() Else Input_Column