DSXchange

I have created a job 7.5 Px with column generator stage for adding new column C20 to the main stream.
But I need to assign a default value "0" to the newly added column.
After that I have lookup stage with reject consition, can I pass some value to the new column C20(from lookup stage), If good then "1", if reject "-1".

Thank you for your help in advance.

I don't think you can assign user defined values in look up stage.

Hi, My question is "Can I send my input to output as below fashion in the lookup stage then ?

Input stream ----> Lookup Stage----> Link1 and Link2(Reject)

Link1
---------
Matched Records (I have to set one column from reference as "1") + Reject records (I have set one column from reference as "0")

Link2
----------
Reject Records (I have to set one column from reference as "0")

Thank you,

below is the job design,you have to use one more transformer stage

Input stream ----> Lookup Stage----->Transformer stage------> Link1 and Link2(Reject)