Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

lmonincx
Contributor 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
MVP
MVP

XML schema of all tables

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

MVP
MVP

XML schema of all tables

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

XML schema of all tables

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

Community Browser