read in data from folder

[paulsparrow]

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);

[marcus_sommer]

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

- Marcus

[thomaslg_wq]

Hi Paul,

Can you show us the script log ?

[shraddha_g]

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.

[paulsparrow]

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

[paulsparrow]

Yes I managed to get that working.  Thanks.