filter in tmap expression

Highlighted
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

Highlighted
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.
Highlighted
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 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog