How to count the number of similar named excels in a folder in Qlik...

[naziralala]

Hi Everyone,

I have come across this situation which requires to add the total number of excels in a folder like

Example- Folder Name - Project

Excels within it are: Test A

Test B, Test C, Test D

The next time it will be 20 excels...similar..

Please assist..

Regards,

Nazira

[maxgro · Accepted solution]

FOR Each File in filelist ('.\Test*.xlsx')

  FileList:

  LOAD

  '$(File)' as FileName,

  FileSize( '$(File)' ) as FileSize,

  FileTime( '$(File)' ) as FileTime

  autogenerate 1;

NEXT File;

LET vNumberOfFile = NoOfRows('FileList');

trace Number Of File is $(vNumberOfFile);

[naziralala]

Hello,

This helped me resolve the issue.

Thanks.