tDropbboxList - How to read all Excel Files in a Dropbox Directory?

Anonymous — Fri, 18 Dec 2015 17:05:09 GMT

Problem: I have a number of Excel Files in a Dropbox Directory and I wish to process them one at a time.
I have been able to successfully read ONE file from Dropbox using tDropboxGet performing the following:

And then process it in another Job:

However, when I need to process multiple files, how do I utilize the tDropboxList component to do that? I have the following for now:

I would ideally like to transfer all the files from the Dropbox Directory to a local directory and then call my job that processes them for each file through a loop. Any recommendations for that?
Thanks for your time.

Re: tDropbboxList - How to read all Excel Files in a Dropbox Directory?

Anonymous — Fri, 18 Dec 2015 19:55:32 GMT

Solved part of the problem - Successfully Fetched all the files from Dropbox to a local directory:

Now, to solve the next part of the problem - Read the Excel Files one at a time and process them in a Job.

topic Re: tDropbboxList - How to read all Excel Files in a Dropbox Directory? in Talend Studio

tDropbboxList - How to read all Excel Files in a Dropbox Directory?

Re: tDropbboxList - How to read all Excel Files in a Dropbox Directory?