topic Re: How to load metadata for multiple .qvd/.qvf file in one app through data load editor. in Connectivity & Data Prep

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

darshan9955 — Wed, 07 Feb 2024 14:31:28 GMT

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)

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

henrikalmen — Wed, 07 Feb 2024 21:42:10 GMT

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

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

darshan9955 — Thu, 08 Feb 2024 05:23:09 GMT

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);

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

Rockstar7 — Thu, 08 Feb 2024 05:27:03 GMT

@darshan9955 Check out this one

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

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

RohanD351 — Thu, 08 Feb 2024 06:24:00 GMT

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.

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

darshan9955 — Thu, 08 Feb 2024 07:32:02 GMT

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]

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

henrikalmen — Thu, 08 Feb 2024 07:37:50 GMT

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

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

darshan9955 — Thu, 08 Feb 2024 07:49:32 GMT

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

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

henrikalmen — Thu, 08 Feb 2024 07:52:28 GMT

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).

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

darshan9955 — Thu, 08 Feb 2024 08:43:59 GMT

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?

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

henrikalmen — Thu, 08 Feb 2024 08:47:08 GMT

https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/DataSource/load-data-from-files.htm

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

Akash_Pohare — Thu, 08 Feb 2024 10:24:44 GMT

Hi,

Please find the script below. Please make sure when you copy the code, the indentions are perfectly matched. Here, first files are listed from a directory, and storing the file names in the variables, and then doing loop to load the files.

---------------------------------------------

sub ScanFolder(Root)

for each FileExtension in '*'

for each FoundFile in filelist( Root & '\*.' & FileExtension)

FileList:

LOAD '$(FoundFile)' as FilePath,

SubField(SubField('$(FoundFile)','.',-2),'/',-1) as FileName

AUTOGENERATE 1;

next FoundFile

next FileExtension

for each SubDirectory in dirlist( Root & '\*' )

call ScanFolder(SubDirectory)

next SubDirectory

end sub

Call ScanFolder('lib://ConnectionName/Folder_From_Files_To_Load/') ;

FileDetails:

LOAD * INLINE
[
1
];

LET vRecordNumber = NoOfRows('FileList');
TRACE 'Number of Records = $(vRecordNumber)';

FOR RecordNumber=1 TO NoOfRows('FileList')

LET vFileToLoadName = PEEK('FileName',RecordNumber-1,'FileList');
TRACE 'File Name to Load = $(vFileToLoadName)';

CONCATENATE(FileDetails)

LOAD
QvBuildNo,
CreatorDoc,
CreateUtcTime,
SourceFileSize,
"TableName",
RecordByteSize,
NoOfRecords,
Offset,
"Length",
%Key_QvdTableHeader_B94FCCAC68ED3E20

FROM [lib://ConnectionName/Folder_From_Files_To_Load/$(vFileToLoadName).qvd]
(XmlSimple, table is QvdTableHeader);

DROP Field "1";

Exit Script;