Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 

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:

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