Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Denis_L
Contributor III
Contributor III

Multiple Excel files load from dropbox in Qlik Sense Business

Hi All,

I am trying to load multiple excel files from dropbox folder on Qlik Sense Business environment.

I tried the following script:

LIB CONNECT TO 'Betting Stats:Dropbox - denis.m.u@gmail.com';

for each file in filelist('lib://Betting Stats:Dropbox - denis.m.u@gmail.com/Football Stats/27122018\*.xlsx')

Test:

load *

from [$(file)](ooxml, embedded labels, table is Match);

next file

 

the load  is working but it does not load any data.

Can you please let me know what I am missing or doing wrong?

Thanks

 

DM
Labels (1)
  • SaaS

24 Replies
Denis_L
Contributor III
Contributor III
Author

Hi Steve,

Thank you very much for your help.

Once I added Concatenate before the Load it worked!

I could not list all the fields as they could be different in each file therefore I had to use *. That created huge synthetic key without the Concatenate command and caused the script  to freeze.

So I just created a table prior to loop and then used Concatenate before the load and it worked.

This is very helpful and will save me a lot of time in the future.

Thank you so much for all your help.

 

 

DM
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

I've pulled notes on loading multiple files from Dropbox, Google Drive and Amazon S3 together into this blog post:

https://www.quickintelligence.co.uk/cloud-file-services-qlik-sense/

Hope people find it useful.

Steve

Denis_L
Contributor III
Contributor III
Author

Thanks Steve, that is very helpful.

I was planning to work on find out how to do this on google drive and your post came just in time!

Thank you very much. 

DM
martina_ag
Contributor
Contributor

Hi Steve,

I'm trying to do something similar for OneDrive, but it doesn't work.

I replaced List with Items, but I can't find the path.

Could you please help me?

Thank you so much

Martina

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

The OneDrive connector has been added recently, and I have not had a chance to play with it yet. It's on my to-do list, as I would like to add a bit about it to my blog.

I can see that it also has separate MetaData and File locations, so the method will most likely be similar.

You will need to use the Select Data button next to the OneDrive Metadata connector and use the wizard to locate the files you need. Insert the load script from that into your load script. Once you have done this you can compare that to the code that I have on my blog for GoogleDrive, S3 and Dropbox (you will see these are all similar but different).

From that you should be able to see what to do with the OneDrive connector.

If you get stuck I will look to get myself a OneDrive account and give it a go.

Steve