This content has been marked as final. Show 8 replies
First time poster here, so forgive any mistakes!
I need to use my load script to get data from a bunch of incremental excel files. The files are ooxml format and share the same column structure.
What changes is the file name and the table name.
|File name||Table (sheet) name|
What I want is to:
This is what I've come up with so far
SET vDataPath = '.\data\';
FOR Each File in FileList ('*.xlsx')
LET a = FileBaseName($(File));
(ooxml, no labels, Table is $(a) );
Basically I know I've stuffed up somewhere, because when I step through the script a evaluates to NULL.