case condition

[monaz]

Hi,

I have an requirement in which i need to check the condition for multiple tables and populate for a single column.

Ex- I need to check
[if tableA.col1=tableB.col1 then tableB.col
else if tableA.Col1=tablec.Col1 then tablec.Col
else tableA.col] as newcolumn

I could write in the stored procedure only for one condition and populate from sybase sybase stage to the transformer, but could not proceed to check remaining condition
-
(when case tabA.col1=tableB.col1 then tableB.col else tableA.col end)as newcolumn

Can anyone guide me in resolving this issue.

[ray.wurlod]

Stream input from table A into Transformer stage, reference inputs from table B and table C. Construct your output column derivation expression according to your logic, remembering to take into account that the "not found" condition will return NULL.

[chulett]

I'm unsure why, assuming you've already made the checks, you don't use the syntax you posted? Your 'if-then-else' construct is perfectly valid and if that's really what you need, use it as the derivation.