Load multiple qvd files but no output

[ced_foning]

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 :

Thanks 

[lironbaram]

hi 

change this 

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

to this 

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

[ced_foning]

@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]

hi 

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

[ced_foning]

@lironbaram 

hi, 

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

[Kushal_Chawda · Accepted solution]

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;