topic Re: filter in tmap expression in Talend Studio

filter in tmap expression

Anonymous — Mon, 02 Nov 2015 20:33:27 GMT

Hi,

I need to apply filter condition in tmap expression editor can you anyone please let know.
row3.ZIP_CLSFN_CDE is not equal to ZIP_CDE_TYP_CDE

Thanks,
Yugandhar

Re: filter in tmap expression

Anonymous — Tue, 03 Nov 2015 08:40:58 GMT

Hi,
We see that you join row3.ZIP_CLSFN_CDE and row4.ZIP_CDE_TYP_CDE from your screenshot. Do you mean the loopup value(row4.ZIP_CDE_TYP_CDE) must be contained in the value of the main(row3.ZIP_CLSFN_CDE)? Or Catch up inner join rejected?
Could you please give us more description about your job?

Best regards
Sabrina

Re: filter in tmap expression

Anonymous — Tue, 03 Nov 2015 14:13:45 GMT

Hi ,

I need to do the lookup on the (row4.ZIP_CDE_TYP_CDE) with the value from the row3.ZIP_CLSFN_CDE( for each mismatch between ZIP_CLSFN_CDE and ZIP_CDE_TYP_CDE) and if any record is not found in the lookup I need to write the mismatched record to the output.

Thanks!