Filter InputFile rows if not present in the other file

Eight 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
Fifteen Stars TRF
Fifteen 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
Eight 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 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Downloads and Trials

Test drive Talend's enterprise products.

Downloads