topic Filter InputFile rows if not present in the other file in Talend Studio

Filter InputFile rows if not present in the other file

Karuetl — Wed, 05 Dec 2018 19:49:40 GMT

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 .

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

TRF — Wed, 05 Dec 2018 20:33:05 GMT

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.

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

Karuetl — Wed, 05 Dec 2018 22:16:15 GMT

There is no columns to join b/w two files

as i said input file is dynamic columns