Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find No Of QVDs in a folder with their names

Hello all, I want to find No Of QVDs in a folder with their names....?????

Like i will give path of a folder and in return i should get how many qvds are there in a folder.

Can anyone help me...?

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

The basic structure you should use is the following:

Set vFolder = 'C:\Users';

for each vFoundFile in filelist( vFolder & '\*.qvd')

  FileList:

  Load '$(vFoundFile)' as SourceFile autogenerate 1;

next vFoundFile

Then you can use Count(SourceFile) to find the number. You could optionally also load the file itself inside the loop.

HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

The basic structure you should use is the following:

Set vFolder = 'C:\Users';

for each vFoundFile in filelist( vFolder & '\*.qvd')

  FileList:

  Load '$(vFoundFile)' as SourceFile autogenerate 1;

next vFoundFile

Then you can use Count(SourceFile) to find the number. You could optionally also load the file itself inside the loop.

HIC

Not applicable
Author

Thanks a lttt Sir....its working fine.