Help to find the required information which is getting executed in the 'For each' statement!

qlikviewforum — Thu, 27 Sep 2012 11:28:29 GMT

Hi All

I am loading data into the table something like below. Problem is it is not getting stored directly into a table. It is getting concatenated with another table called 'Detail'. What I wanted to do is to find the NoOfColumns, NoOfRows and LoadDuration of the table which is getting concatenated in the below For statement. Hope someone can help me out on this!

For each zSerialNo in $(zSerialNos)
Concatenate (Detail)
Load * from (qvd)
next zSerialNo;

Thanks,

Qlikviewforum

Re: Help to find the required information which is getting executed in the 'For each' statement!

whiteline — Fri, 28 Sep 2012 14:49:11 GMT

Hi.

You can use some functions, to get info from qvd files:

QvdCreateTime(filename)
Returns the XML-header time stamp from a QVD file if any (otherwise NULL).
The filename is the name of a QVD file, if necessary including path.

QvdNoOfRecords(filename)

Returns the number of records currently in a QVD file.

The filename is the name of a QVD file, if necessary including path.

QvdNoOfFields(filename)

Returns the number of fields in a QVD file.

The filename is the name of a QVD file, if necessary including path.

QvdFieldName(filename , fieldno)

Returns the name of field number fieldno, if it exists in a QVD file (otherwise NULL).

The filename is the name of a QVD file, if necessary including path.

The fieldno is the number of the field (0 based) within the table contained in the QVD file.
QvdTableName(filename)
Returns the name of the table contained in a QVD file.
The filename is the name of a QVD file, if necessary including path.

topic Re: Help to find the required information which is getting executed in the 'For each' statement! in QlikView

Help to find the required information which is getting executed in the 'For each' statement!

Re: Help to find the required information which is getting executed in the 'For each' statement!