px stage variable

[forboy]

hi,

Iam using parallel trasnformer in which Iam using 20 stage variables for complex calculations,If one of the input variable coming is null, then I got to set entire thing to null, but px stage varible doen't allow null values assigning to it, How can I do it.

[roy]

Hi,
you have several options:
1. you could have 2 links 1 transforming rgular records and the other taking the NULL records.
you might need to build 2 seperate files and go on from there.
2. Add another Stage Variable that will be turned @TRUE in case one of the columns is null, put a If Then Else in your derivations to put hte proper values in case that SV is @TRUE (use the added SV in case all or many columns need this info)

There are probably more options.

IHTH,

[forboy]

thanks roy,

Iam just wondering can we assign @true for a decimal, because my calculations comes like this
a * b =c c is a stage varible (decimal)

if a or b are null then it should be set to null, I can't use c in regular varible because Iam using c again in many calculations.