Filter InputFile rows if not present in the other file

Seven Stars

Filter InputFile rows if not present in the other file

Input File is delimited with dynamic columns (column positions can change and has no column names)

aaaa,672,newjersey

mmmm,999,california 

safdsaf,895,newyork 

 

 

 

Lookup File

999

248

895

 

output should be 

File

aaaa,672,newjersey

 

 

how can i achieve it . 

Highlighted
Forteen Stars TRF
Forteen Stars

Re: Filter InputFile rows if not present in the other file

Use a tMap to construct an inner join between your main and your lookup file. Then define an output flow with the option "catch inner join reject".
The Talend documentation explains this point with details.

TRF
Seven Stars

Re: Filter InputFile rows if not present in the other file

There is no columns to join b/w two files 

 

as i said input file is dynamic columns 

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.