Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
ced_foning
Contributor III
Contributor III

Load multiple qvd files but no output

Hi Everyone, 

i'm trying to load multiple qvd files and put it in one table. Here's my code : 

 

Set QVDFolder = ('$(QLK_CUBE_PATH)\FIM\RWA_WEIGHT\qvd\CVAR');

For Each vFiles in FileList (QVDFolder&'\CVARiskReport*.qvd')


RWA_WEIGHT_CVARR:
LOAD Ricos

FROM [$(vFiles)](qvd);


Next vFiles

 

But at the end, Qlik doesn't create the table RWA_WEIGHT_CVARR. 

I've tried to look into logs, but i have just this :

Capture.PNG

 

Thanks 

Labels (2)
1 Solution

Accepted Solutions
Kushal_Chawda

try this

Set QVDFolder = ('$(QLK_CUBE_PATH)\FIM\RWA_WEIGHT\qvd\CVAR');

RWA_WEIGHT_CVARR:
load * inline [
Temp ];

For Each vFiles in FileList ($(QVDFolder)&'\CVARiskReport*.qvd')

concatenate(RWA_WEIGHT_CVARR)
LOAD Ricos,
     filebasename() as FileName
FROM [$(vFiles)](qvd);

Next vFiles

drop field Temp;

View solution in original post

5 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

change this 

For Each vFiles in FileList (QVDFolder&'\CVARiskReport*.qvd')

to this 

For Each vFiles in FileList ($(QVDFolder)&'\CVARiskReport*.qvd')

ced_foning
Contributor III
Contributor III
Author

@lironbaram 

I don't have the error anymore, but it has created multiple qvd table. 
What i want is to load multiple qvd files, and have it in one table. 

 

Thanks

lironbaram
Partner - Master III
Partner - Master III

hi 

do you load the same fields from all of your QVD files ?

ced_foning
Contributor III
Contributor III
Author

@lironbaram 

hi, 

NO, it's not the same fields, i've reduced some. 

 

Kushal_Chawda

try this

Set QVDFolder = ('$(QLK_CUBE_PATH)\FIM\RWA_WEIGHT\qvd\CVAR');

RWA_WEIGHT_CVARR:
load * inline [
Temp ];

For Each vFiles in FileList ($(QVDFolder)&'\CVARiskReport*.qvd')

concatenate(RWA_WEIGHT_CVARR)
LOAD Ricos,
     filebasename() as FileName
FROM [$(vFiles)](qvd);

Next vFiles

drop field Temp;