filter in tmap expression

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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!