Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
Hello,
This helped me resolve the issue.
Thanks.