Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lmonincx
Creator II
Creator II

XML schema of all tables

Hi,

Can someone tell me if it's possible for a system to create an xml file which contains all the tables possible to deliver?

customer is now delivering many files each time containing sometimes different combinations of data tables, i am looking for a complete overview of all possible tables.

Thanks!

3 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

What "system" do you mean in your question - QlikView or the source database ?

If you are using a standard ODBC connection, you should be able to use SQL functions:

SQLTABLES;

SQLCOLUMNS;

and get a complete list of your tables.

not sure if this is what you are looking for...

Oleg

rbecher
MVP
MVP

Hi,

you can read header informations from QVD files into QV like this:

QvdFieldHeader:
LOAD Left(FileName(), len(FileName())-4) as QVDName, *;
LOAD FieldName,
BitOffset,
BitWidth,
Bias,
NoOfSymbols,
Offset as HeaderOffset,
Length as HeaderLength,
[NumberFormat/Type] as Type,
[NumberFormat/nDec] as nDec,
[NumberFormat/UseThou] as UseThou,
[NumberFormat/Fmt] as Fmt,
[NumberFormat/Dec] as Dec
FROM $(qvdFile)(XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);

QvdTableHeader:
LOAD Left(FileName(), len(FileName())-4) as QVDName, *;
LOAD QvBuildNo,
CreateUtcTime,
SourceFileSize,
TableName,
RecordByteSize,
NoOfRecords,
Offset,
Length
FROM $(qvdFile)(XmlSimple, Table is [QvdTableHeader]);

You could also reuse this xml part of the QVD file w/o reloading it.

Maybe this helps.

Ralf

Astrato.io Head of R&D
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

There are also a number of Qvd*() functions that can be used to get information about the contents of QVDS. They functions are listed in the "System Functions" section of the Ref Guide.

-Rob