records dropped in transformer

[mab_arif16]

Hi
In one of my job , a transformer which checks the following null condition
if ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) then RM_NULLS.COL3= RM_NULLS.COL4 else RM_NULLS.COL3
for which I am getting warning
APT_CombinedOperatorController,0: Field 'COL1' from input dataset '0' is NULL. Record dropped.

I tried giving a reject link ,but it didnt work ,is there some way to get rid of this warning.
Thanks
Arif

[kris007]

Hi
In one of my job , a transformer which checks the following null condition
if ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) then RM_NULLS.COL3= RM_NULLS.COL4 else RM_NULLS.COL3
for which I am getting warning
APT_CombinedOperatorController,0: Field 'COL1' from input dataset '0' is NULL. Record dropped.

I tried giving a reject link ,but it didnt work ,is there some way to get rid of this warning.
Thanks
Arif

Make sure you perform ISNULL check on COL1 in all the references.

[pavankvk]

I had a similar problem.

i used another transformer to check IsNull(column) Then set 'X' and in the actual transformer i checked for value of 'X'.

[mab_arif16]

Hi
In one of my job , a transformer which checks the following null condition
if ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) then RM_NULLS.COL3= RM_NULLS.COL4 else RM_NULLS.COL3
for which I am getting warning
APT_CombinedOperatorController,0: Field 'COL1' from input dataset '0' is NULL. Record dropped.

I tried giving a reject link ,but it didnt work ,is there some way to get rid of this warning.
Thanks
Arif

Make sure you perform ISNULL check on COL1 in all the references.

Thats the only palce where I am referencing column 1.
Thanks
Arif

[kris007]

Are you getting this error message in Transformer stage or in the input dataset stage?If input dataset make sure you are handling nulls for that column.

[kumar_s]

Is your COL1 column marked as NotNull?
If so handle null for that column.
Also try turning Combinabiltiy to false and rerun the job.

[ukyrvd]

I had similar problem. In my case, the isnull check and the transformation logic is in StageVariable derivation. If I move that to output column derivation, DS is happy!!

[ray.wurlod]

You don't do assignment in expressions. The original expression should be

Code: Select all

If ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) Then  RM_NULLS.COL4 Else RM_NULLS.COL3