qualify in loop

[amien]

why does this not work? my table (fact) is gone.

FOR EACH file in FILELIST('\*.xlsx')

QUALIFY *;
UNQUALIFY "%*_key";

sales:
LOAD ......
FROM
$(file)
(ooxml, embedded labels, header is 1 lines, table is Sales);

UNQUALIFY *;

fact:
LOAD *
RESIDENT sales;

DROP TABLE sales;

NEXT file;

[amien]

strange .. the problem is when i execute above script .. there is no 'fact'table .. but when i change

fact:
LOAD *
RESIDENT sales;

to

fact:
LOAD *,filename()
RESIDENT sales;

then i see all the column.
can only one explain this?

[#3]

try altering the fact load as follows:

fact:
noconcatenate LOAD *
RESIDENT sales;