I have a list of excel files 201401.xlsx,201402.xlsx,201403.xlsx ..... until 201505.xlsx
the first loads works perfect where i wna load all data before 201404 including 201404
Load
FROM
(ooxml, embedded labels, table is Export)
Where SubField(Filename(),'.',1)<=201504;
the second load gives alot of table not found error
FROM
(ooxml, embedded labels, table is Export)
Where SubField(Filename(),'.',1)>201504;
This works fine
so if i changed it to load 201505 file only i get no table found errors, and the field names in the previous load is a copy and past to the ones used here , so this tells me its the where clause and not the fields missing
