Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Karuetl
Creator II
Creator II

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 . 

Labels (2)
2 Replies
TRF
Champion II
Champion II

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.
Karuetl
Creator II
Creator II
Author

There is no columns to join b/w two files 

 

as i said input file is dynamic columns