Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I load files with:
Table:
LOAD *;
SELECT *
FROM ../../QVD/*DATA.qvd (qvd);
Can I count how many files i have loaded in the report?
Don't know about files but tables you can count as below
NoOfTables()
One way to achieve this would be something like this:
Table:
LOAD
filename() as filename,
*
FROM
[../../QVD/*DATA.qvd] (qvd);
FileCount:
LOAD
Count(DISTINCT filename) as FileCount
RESIDENT Table;
LET vFileCount = peek('FileCount', -1);
DROP TABLE FileCount;