Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
hi
change this
For Each vFiles in FileList (QVDFolder&'\CVARiskReport*.qvd')
to this
For Each vFiles in FileList ($(QVDFolder)&'\CVARiskReport*.qvd')
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
hi
do you load the same fields from all of your QVD files ?
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;