Count loaded files?

[qlikconsultant]

I load files with:

Table:

LOAD *;

SELECT *

FROM ../../QVD/*DATA.qvd (qvd);

Can I count how many files i have loaded in the report?

[MK_QSL]

Don't know about files but tables you can count as below

NoOfTables()

[marcus_malinow]

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;