Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.