How to load metadata for multiple .qvd/.qvf file in one app through data load editor.

[darshan9955]

Consider I have multiple .qvd files at one folder and no app is created in Qlik Sense desktop.

So, How can I load multiple .qvd files into my data load editor at once (using script), so that I can see metadata of the multiple .qvd files. (Manually adding .qvd files is not preferred)

[henrikalmen]

You can iterate with for...next and filelist() - see https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptControlStatements...

[darshan9955]

I am getting above error while loading .qvd file into qliksense.
------------------------------------------------
query used mentioned below
[QvdTableHeader_135d64f6-4bb4-8ba0-0395-b5d39d9c]:
LOAD
[QvBuildNo],
[CreatorDoc],
[CreateUtcTime],
[SourceFileSize],
[TableName],
[RecordByteSize],
[NoOfRecords],
[Offset] AS [QvdTableHeader.Offset],
[Length] AS [QvdTableHeader.Length],
[%Key_QvdTableHeader_B94FCCAC68ED3E20] AS [QvdTableHeader.%Key_QvdTableHeader_B94FCCAC68ED3E20]
FROM [lib://test1/abb1aed53c9e40ac019a6e52c2afbf6d.qvd]
(XmlSimple, table is QvdTableHeader);

[Rockstar7]

@darshan9955 Check out this one

https://github.com/eapowertools-archive/qs-qvd-monitor

[RohanD351]

Try this :

for each i in list of all qvd folder connections in single quotes

for each file in filelist ('lib://$(i)'&'/*.qvd')

T:
LOAD
QvBuildNo,
CreatorDoc,
CreateUtcTime,
SourceFileSize,
"TableName",
RecordByteSize,
NoOfRecords,
Offset,
"Length",
filename() as QVD_Name,
'$(file)' as File_name,
'$(i)' as Connection_Name,
%Key_QvdTableHeader_B94FCCAC68ED3E20
FROM [$(file)]
(XmlSimple, table is QvdTableHeader);

next file;

next i;

Regards,

Rohan.

[darshan9955]

Hi Rohan thanks for the reply, can you please help me to load single .qvd file with the above code.

file location is same [lib://test1/abb1aed53c9e40ac019a6e52c2afbf6d.qvd]

[henrikalmen]

LOAD *
FROM [lib://test1/abb1aed53c9e40ac019a6e52c2afbf6d.qvd]
(XmlSimple, table is QvdTableHeader);

[darshan9955]

I am using newly created app to load this .qvd file via data load editor.

[henrikalmen]

Well, you have a very clear error message there: "Connection not found: test1". It seems you have not defined a data connection named test1, or that the current user trying to reload the app doesn't have rights to use that connection (in that case the data connection test1 isn't visible in the connections panel in the script editor).

[darshan9955]

Test1 is folder name in which multiple .qvd files are present. I am able to make connection to .qvd file in test1 folder, through data load manager but making connection to test1 folder, how to do it?