Script Load all Files in a Directory

[EvanBarrick]

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.

[Seyko · Accepted solution]

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.

[EvanBarrick]

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