filter in tmap expression

One Star

filter in tmap expression

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

Moderator

Re: filter in tmap expression

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: filter in tmap expression

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!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now