Page 1 of 1

Dropping records in a PX transformer

Posted: Mon May 17, 2004 11:48 am
by vjreddy65
Iam doing a left outer join and have a transformer following that. I have some Null handling, other checks and derivations in the Transformer but no constraints. It appears that the Transformer is dropping certain records where I have not matching records from the right link (These values should be null in a left outer join). Any tips would be highly appreciated.

-vj

Posted: Mon May 24, 2004 6:54 pm
by asadi
If you attempt to evaluate nulls within a transformer PX will drop those rows automatically. Before running any functions or evaluations on a suspect null value check for nulls before you process.