How to write this CASE in Talend

Anonymous — Sat, 16 Nov 2024 04:05:50 GMT

Team,

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,

Re: How to write this CASE in Talend

manodwhb — Mon, 18 Nov 2019 13:19:11 GMT

@rohitatcs , are WD.SUM_ALL_DAYS and WD.SUM_YTD_DAYS fields?

Re: How to write this CASE in Talend

Anonymous — Tue, 19 Nov 2019 04:56:45 GMT

@manodwhbYes, it is.

topic Re: How to write this CASE in Talend in Talend Studio

How to write this CASE in Talend

Re: How to write this CASE in Talend

Re: How to write this CASE in Talend