Unknown LOAD statement error

[EvanBarrick]

I am attempting to run the following script:

thsSALESDATA:
BUFFER (incremental) LOAD * FROM [lib://THS Aggregate (brand_mike.smith)/*.xlsx](ooxml, embedded labels, table is THS);

STORE thsSALESDATA INTO [lib://QVD (brand_mike.smith)/THSaggregate.qvd(qvd)];

There are three files in the directory from which I am loading; they all have the same number of columns and exactly the same headers. 

What could be causing this error?

[dplr-rn]

can you share the error log/output

[EvanBarrick]

The following error occurred:

Unknown LOAD statement error

The error occurred here:

TMsalesData: BUFFER (incremental) LOAD * FROM [lib://TMaggregate (brand_mike.smith)/*.xlsx](ooxml, embedded labels, table is TM)

The following error occurred:

Unknown LOAD statement error

The error occurred here:

?

[dplr-rn]

Hard to help my friend.
but buffer incremental afik only works on text files (csvs) not xlsx
not sure if this is the cause but worth a try

[EvanBarrick]

I have used this script for similar directories with .xlsx files several times, which is why this is puzzling

[dplr-rn]

to identify the error i recommend Trying to load the files without the *.xlsx
if you have a lot of files there try a loop like below you can eliminate issues with the files

set vRoot = '.';
FOR Each File in filelist ('$(vRoot)'&'\*.xlsx')
Temp:
LOAD *
FROM
[$(File)]
(ooxml, no labels, table is data);
let qvdname= replace(File,'xlsx','qvd');


next File

[EvanBarrick]

Thanks for this, where do I designate where my directory in your example?

[dplr-rn]

vRoot 

[dplr-rn]

personally i dislike load with *.xlsx hard to pin down errors. e.g. someone put a extra space in tab name etc.
i tend to use a loop like this which will error out at the exact file which causes problem

[EvanBarrick]

set vRoot = '.';

FOR Each File in filelist ('$(The Store Name Agg (brand_mike.smith)\*.xlsx')
Temp:
LOAD *
FROM
[$(File)]
(ooxml, no labels, table is THS);
let qvdname= replace(File,'xlsx','qvd');

next File