need to convert below case statement in talend

genupula — Sat, 16 Nov 2024 03:29:15 GMT

Hi All,

i need to convert the below case statement in talend

CASE WHEN mcw_qualitypot_prod_event_deduped.qualitypot_prod_task_type ="IMAGE_REVIEW"
AND mcw_qualitypot_prod_event_deduped.qualitypot_prod_error :: text ='incorrectRejected'
THEN count(
mcw_qualitypot_prod_event_deduped.qualitypot_prod_error
) ELSE NULL END AS quality_incorrectrejectedpots,

please provide solution for the above requirement

Re: need to convert below case statement in talend

TRF — Thu, 23 Jan 2020 08:09:27 GMT

You may have a sequence with a name based on the value of both qualitypot_prod_task_type + qualitypot_prod_error fields:

Numeric.sequence(row1.qualitypot_prod_task_type+row1.qualitypot_prod_error, 1, 1)

Use this to populate a global variable or tMap local variable and get the result where needed.

topic need to convert below case statement in talend in Talend Studio

need to convert below case statement in talend

Re: need to convert below case statement in talend