need to convert below case statement in talend

[genupula]

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

[TRF]

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.