We are using TOS and we are looking to write this CASE in Talend.
Can you please provide full code for this.
CASE WHEN WTR IS NULL AND BNP IS NULL THEN 'MOP' WHEN WTR = 0 AND BNP = 0 THEN 'MOP' WHEN WTR > 0 AND BNP < 0 THEN 'WNT' WHEN WTR < 0 AND BNP > 0 THEN 'BNP' WHEN WTR < 0 AND BNP < 0 THEN 'MOP' WHEN (WTR IS NULL OR WTR = 0) AND BNP <= 0 THEN 'MOP' WHEN (BNP IS NULL OR BNP = 0) AND WTR <= 0 THEN 'MOP' WHEN (WTR IS NULL OR WTR = 0) AND BNP > 0 THEN 'BNP' WHEN (BNP IS NULL OR BNP = 0) AND WTR > 0 THEN 'WNT' WHEN cast (WTR as DECIMAL) / NULLIF(BNP,0) <= 0.4 AND cast (WTR as DECIMAL) / NULLIF(BNP,0) > 0 THEN 'BNP' WHEN cast (WTR as DECIMAL) / NULLIF(BNP,0) > 0.4 AND cast (WTR as DECIMAL) / NULLIF(BNP,0) < 1.6 THEN 'MOP' WHEN cast (WTR as DECIMAL) / NULLIF(BNP,0) >= 1.6 THEN 'WNT' END AS TYPE, (CAST(PASSANGER_REV as DECIMAL ) * WD.SUM_ALL_DAYS/ WD.SUM_YTD_DAYS ) AS EXTRAPOLATED,
