Real-Time Loading of Multiple Sets of Data Onto Qlik
Hi, could anyone here share tips on how to produce a script that's versatile enough to load multiple sets of excel sheets without having to manually script each sheet every time there's an updated record/ a new file to be loaded? All this, and without looping or connecting to any database whatsoever.
Here's what I've come up with so far:
ConcatenateTABLE: LOAD 1 as ID, 2 as Year, 3 as Type, 4 as Amount, 5 as Remark FROM [lib://AttachedFiles/*.xlsx] (ooxml, header is 1, TABLE is MBS);
This script loads the data OK, apart from the creation of one synthetic key.
The issue is that when I try to view on Data Manager whatever I've scripted, this new table (MBS) is completely void of data.