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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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:
0683p000009MCkg.jpg 
 
And then process it in another Job:
0683p000009MCkl.jpg
However, when I need to process multiple files, how do I utilize the tDropboxList component to do that? I have the following for now:
0683p000009MCdq.jpg
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.
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Solved part of the problem - Successfully Fetched all the files from Dropbox to a local directory:
  0683p000009MCkq.jpg 0683p000009MCgR.jpg
Now, to solve the next part of the problem - Read the Excel Files one at a time and process them in a Job.