QVD Dictionary

Zaga_69 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am looking for a code that allows me to create a table like the one below:

QVD NAME FIELDS

QVD_1 Field_1

QVD_1 Field_2

QVD_2 Field_1

The QVDs are located in different folders in the server.

Any idea?

Much appreciated your hep,

Edi

Re: QVD Dictionary

zhadrakas — Tue, 29 Oct 2019 12:35:41 GMT

Try this one:

Short:

for each vFile in FileList('C:\PATH\*.qvd') let vFileName = mid(vFile, index(vFile, '\', -1) + 1, 99); QvdFields: LOAD '$(vFileName)' as [File Name], FieldName as [Field Name] FROM [$(vFile)] (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]); next

complete:

for each vFile in FileList('C:\PATH\*.qvd') let vFileName = mid(vFile, index(vFile, '\', -1) + 1, 99); QvdFields: LOAD 1 as FieldCount, '$(vFileName)' as [File Name], FieldName as [Field Name], BitOffset as [Bit Offset], BitWidth as [Bit Width], Bias as [Bias], NoOfSymbols as [No Of Symbols], [NumberFormat/Type] as Type, [NumberFormat/nDec] as Dec, [NumberFormat/UseThou] as UseThou FROM [$(vFile)] (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]); QvdTableHeader: LOAD 1 as QVDCount, '$(vFileName)' as [File Name], QvBuildNo as [QV Build No], CreatorDoc as [QVD Creator], CreateUtcTime as [Time Created], SourceFileSize as [Source File Size], TableName as [Table Name], RecordByteSize as [Record Byte Size], NoOfRecords as [Number Of Records] FROM [$(vFile)] (XmlSimple, Table is [QvdTableHeader]); next

regards

tim

topic Re: QVD Dictionary in QlikView

QVD Dictionary

Re: QVD Dictionary