Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

varmekontrol
New Contributor II

Load all files from folder ( FTP and DropBox)

Hi

I am using Qlik sense Cloud to automatically reload data on a daily basis.

The data I would like to load consist of .csv files from one or more folders, so I don´t only want to load 1 file, but sometimes thousands.

Normally I would just make do this.

Load

    data1

    data2

FROM [lib://location-data/*]

But it fails when I am trying to do the same with DropBox

LIB CONNECT TO 'Valuereport (qlikcloud_qlikid)';

Load

    data1

    data2

FROM [lib://Valuereport (qlikcloud_qlikid_varmekontrol)/folder1\location-data\*]

And fails when doing it with FTP (Witch I would prefer)

Load

    data1

    data2

FROM [lib://valuereportsa (qlikcloud_qlikid)]

Udklip.JPG

1 Reply

Re: Load all files from folder ( FTP and DropBox)

I'm not sure about dropbox - the synchronized dropbox folder on your local machine should work as datasource for loading with wildcards but per url I doubt that it will be possible.

By FTP no filefunctions which include wildcards will work else you will always need a absolute path or a batch which fetch the data before you could load them into Qlik. Here an example of it: Re: For Each File in Filelist - FTP load is not working?

- Marcus