topic Re: Script Load all Files in a Directory in App Development

Script Load all Files in a Directory

EvanBarrick — Tue, 19 Mar 2019 14:08:35 GMT

I have a directory of Excel Files that I am trying to pull into my Qlik Sense Application.

The directory has 5 files named:

2014-2015

2015-2016

2016-2017

2017-2018

2018-2019

I am doing the following for my load script:

MyTable:
BUFFER (incremental) LOAD * FROM [lib://Data (name_john.smith)/Broadcast/*.xlsx] (ooxml, embedded labels, table is [BROADCAST]);

The load works fine, but I am getting a synthetic key. I essentially want this to create one large table, which would eliminate any synthetic keys.

Re: Script Load all Files in a Directory

Seyko — Tue, 19 Mar 2019 14:22:54 GMT

Hello Evan,

To avoid synthetic keys and obtain only large table (by a natural join) your tables must have the same number of fields and this fields must have identical names.

cordially.

Re: Script Load all Files in a Directory

EvanBarrick — Tue, 19 Mar 2019 14:35:39 GMT

Understood, which is why I am struggling with this. All files have met that criteria