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: 
alsahly2017
Contributor III
Contributor III

Qlik Sense - I have Problem in Loading multiple QVDs Using *

Hello And Welcome.

I am facing a problem with loading multiple qvds, it was working fine before.

The bellow code works fine.

 

 

LOAD
    USERNAME,
    LOGON_TIME,
    LOAD_TIME
FROM [lib://MY-QVDs (qlik_admin)/S1/LOCK_USERS_220628_100615.qvd]
(qvd);

 

 

 

However, once I want to read all qvd files it gave me error

 

 

LOAD
    USERNAME,
    LOGON_TIME,
    LOAD_TIME
FROM [lib://MY-QVDs (qlik_admin)/S1/LOCK_USERS_*.qvd]
(qvd);

 

 

alsahly2017_0-1656480469904.png

 

Thank You

 

 

 

Labels (2)
1 Solution

Accepted Solutions
alsahly2017
Contributor III
Contributor III
Author

LOAD
    USERNAME,
    LOGON_TIME,
    LOAD_TIME
FROM [lib://MY-QVDs (qlik_admin)/S1/LOCK_USERS_2*.qvd]
(qvd);

It works for me when I set the * after number 2, 

I realized that there are other QVDs which has the same name such as "LOCK_USERS_BLOCKING_A123" and so on.

View solution in original post

1 Reply
alsahly2017
Contributor III
Contributor III
Author

LOAD
    USERNAME,
    LOGON_TIME,
    LOAD_TIME
FROM [lib://MY-QVDs (qlik_admin)/S1/LOCK_USERS_2*.qvd]
(qvd);

It works for me when I set the * after number 2, 

I realized that there are other QVDs which has the same name such as "LOCK_USERS_BLOCKING_A123" and so on.