Null Representation

prasad v · Post by **prasad v** » Fri Sep 04, 2015 9:03 am

Hi

I am facing an issue with Null Values in integer field from file.

What i am doing here is I am validating the null value using
If (IsNull(lnk_In.col1) or trim(lnk_In.col1)="") Then "NULL" Else "NONNULL".

then i put condition while loading into table only to move the data when the above stage variable is "NONNULL".

However i am getting below error on null value.

Tfm_Validate,0: Field 'col1' from input dataset '0' is NULL. Record dropped.

ArndW · Post by **ArndW** » Fri Sep 04, 2015 9:15 am

The condition as you've posted is OK and is not causing the warning/error. Somewhere else in your transform stage you are doing an operation on col1 which is triggering the message.

prasad v · Post by **prasad v** » Fri Sep 04, 2015 9:24 am

in mapping i have defined output column expression as inputcolumn and mentioned null=No.

I am not sure what i am doing wrong.

Thanks

ArndW · Post by **ArndW** » Fri Sep 04, 2015 10:03 am

Although conditions are usually evaluated left-to-right and an OR condition stops evaluations once one TRUE is found, perhaps you could try

Code: Select all

If IsNull(lnk_In.col1) THEN "NULL" ELSE IF trim(lnk_In.col1)="" Then "NULL" Else "NONNULL"

ray.wurlod · Post by **ray.wurlod** » Fri Sep 04, 2015 11:17 pm

Check the Transformer stage properties to determine whether you have legacy null handling enabled.

prasad v · Post by **prasad v** » Sat Sep 05, 2015 6:44 am

Legacy null handling is disabled in the Transformer.