DSXchange

hi ,
as Franklin and UCDI suggested, i broke into single statement using stage variables. then i created a new column with conditions.
This works and is much simpler

Thanks to all

Hi Franklin, thanks for this new approach. i will it a try

Sure. tried IsNotNull then got same unexpected output.

how to evaluate multiple if---then in Transformer? maybe my syntax is wrong

i appreciate any help

Thanks.

Hi Chulett,
thanks for reply

i am checking only non null string from multiple columns (A,B,C,..). If it is not null then evaluate to constant value

don't know if this answers to your question...

Hello, I am using 11.5 PX. When I try this IF THEN clause in Transformer stage: if columnA <> '' then 'RT' else if columnB <> '' then 'RT' else if columnC <> '' then 'RT' else if columnD <> '' then 'RT' else if columnE <> '' then 'RC' else if columnF <> '' then 'RF' else '' Unfortunately, this alway...