Looping over Lookup files

Four Stars

Looping over Lookup files

Hi,

 

There is a logical doubt. I am iterating over the files and file names changes with the iteration value. So, when I do this, lookup file is loaded only once and not on every iteration. I want it to load on every iteration. Can this be possible?Screen Shot 2019-01-21 at 5.51.07 PM.png

Eleven Stars

Re: Looping over Lookup files

Can you try "Reload on Each Row (Cache)" option

This could help. Let me know.
Regards
Abhishek KUMAR
Four Stars

Re: Looping over Lookup files

 

It just worked like Reload at each record.

 

Thanks,

Suneel.

Eleven Stars

Re: Looping over Lookup files

Also can you try to change the link between tJava and tInputExcel to OnComponentOK. This should also worK.
Regards
Abhishek KUMAR

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now