Records Dropping because of 0 values

[vemisr]

Hi Experts,

i am doing calculations in minutes and $ values, i am getting 0 values .

it has to send these records with acct_number and amount 'zero values' to target. but it's droping. tried with datatype "decimal' and 'numeric' also , still records are doped.

here is the log : "Field 'ED_LOS_GRP_MIN' from input dataset '0' is NULL. Record dropped. "


thx
Vemisr

[anbu]

Records are dropped since you have NULL in the field ED_LOS_GRP_MIN. Check for NULL in this field and assign default values

[vemisr]

put a if condition then assigned to 00 , still same errors.

[vivekgadwal]

put a if condition then assigned to 00 , still same errors.

Then what is the workaround that you got? Enlighten us...

[Shaanpriya]

Hi Experts,

i am doing calculations in minutes and $ values, i am getting 0 values .

it has to send these records with acct_number and amount 'zero values' to target. but it's droping. tried with datatype "decimal' and 'numeric' also , still records are doped.

here is the log : "Field 'ED_LOS_GRP_MIN' from input dataset '0' is NULL. Record dropped. "


thx
Vemisr

Datatype issues also causes the records to be dropped. Double check the types

[smeliot]

What is the If statement that you used? Are you using one of the NullTo... functions?