topic Re: read in data from folder in App Development

read in data from folder

paulsparrow — Wed, 06 Sep 2017 16:03:30 GMT

Trying to read in data from multiple files in a folder. In QlikView I did a loop to grab file names and then looped to grab the data. QlikSense needs to create connections by the looks of it. Is there a way to grab all file information under a folder?

Tried this and it didn't work:

LOAD

FROM [lib://EBIFiles/*.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Main);

Re: read in data from folder

marcus_sommer — Thu, 07 Sep 2017 10:29:00 GMT

I think you need to enable the Qlik Sense Legacy mode.

- Marcus

Re: read in data from folder

thomaslg_wq — Thu, 07 Sep 2017 10:38:13 GMT

Hi Paul,

Can you show us the script log ?

Re: read in data from folder

shraddha_g — Thu, 07 Sep 2017 10:50:04 GMT

You can use same script as that you used in qlikview.

You will only have to change path. Replace actual path with connection path.

It works.

Re: read in data from folder

paulsparrow — Thu, 07 Sep 2017 17:19:10 GMT

Doesn't look like Legacy mode will work due to server situation.

Re: read in data from folder

paulsparrow — Thu, 07 Sep 2017 17:19:41 GMT

Yes I managed to get that working. Thanks.