Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

qlikviewforum
Contributor II

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

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

1 Reply
whiteline
Honored Contributor II

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

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.