topic Re: How to perform below CASE statement in Talend in Talend Studio

How to perform below CASE statement in Talend

Anonymous — Sat, 16 Nov 2024 04:19:13 GMT

Hi Team,

We need to implement below CASE statement in Talend. Please suggest the design for the same.

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 DECIMAL(WTR,17,5) / NULLIF(BNP,0) <= 0.4 AND DECIMAL(WTR,17,5) / NULLIF(BNP,0) > 0 THEN 'BNP'
WHEN DECIMAL(WTR,17,5) / NULLIF(BNP,0) > 0.4 AND DECIMAL(WTR,17,5) / NULLIF(BNP,0) < 1.6 THEN 'MOP'
WHEN DECIMAL(WTR,17,5) / NULLIF(BNP,0) >= 1.6 THEN 'WNT'

END AS TYPE

We are using TOS.

Re: How to perform below CASE statement in Talend

TRF — Mon, 21 Oct 2019 13:51:59 GMT

As the expression is a little bit complicated, I suggest you to use a tJavaRow instead of ternary expression within a tMap component. This you can use regular "if-then-else" notation which may help for readability.

Re: How to perform below CASE statement in Talend

Anonymous — Mon, 21 Oct 2019 14:04:05 GMT

Thanks for your reply.

Can you please provide some example or link where I can read through this approach.