How to load first 10 qvd files from folder

[tusharneral]

How to load first 10 qvd files from folder.

[Kashyap_R]

Hi

Can u please tell me the qvd names and how u want to load it?

Thanks

[nikitadeshwal]

Hi,

You can use this,

for count= 1 to 10 ;
LOAD
*
FROM [lib://Connection_Name/Folder_Name/$(count).qvd]
(qvd);

next

Just your qvds should have named in 1,2,3...100 formate

Regards,

Nikita Deshwal

[Anil_Babu_Samineni]

How about this?

FOR Each File in FileList('File Name List Path')

Qvd_List:

    LOAD '$(File)' AS QVD_Name,

             FileTime('$(File)') AS QVD_Modified_Date

    AutoGenerate(1);

Next File

First_10_QVD_Load:

FIRST 10 LOAD QVD_Name,

     QVD_Modified_Date

RESIDENT Qvd_List ORDER BY QVD_Modified_Date DESC;

DROP TABLE Qvd_List;