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!