Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pb0
Contributor
Contributor

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.

Would appreciate your tips!

0 Replies