1 Reply Latest reply: Sep 28, 2012 10:49 AM by whiteline _ RSS

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

    Rikab Kothari

      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 [C:\Data.qvd](qvd)
      
      next zSerialNo;
      

       

      Thanks,

      Qlikviewforum

        • Re: Help to find the required information which is getting executed in the 'For each' statement!
          whiteline _
          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.