topic qualify in loop in QlikView

qualify in loop

amien — Sat, 12 Feb 2011 12:50:36 GMT

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;

qualify in loop

amien — Sat, 12 Feb 2011 14:24:58 GMT

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?

qualify in loop

Sat, 12 Feb 2011 15:53:58 GMT

try altering the fact load as follows:

fact:
noconcatenate LOAD *
RESIDENT sales;