2 Replies Latest reply: Aug 4, 2017 1:22 AM by Arvind Patil RSS

    loading fields from empty qvd

    Didier Agonvonon

      Hello,

       

      I am having some issue getting this concept to work, any suggestion is appreciated.

       

       

      I have an empty qvd that is generated daily. I would like to get the list of fields from that empty QVD into a new field (Fieldlist).

      the script below is returning nothing for field list.

       

       

      TABLE:

      Load * FROM

      [C:\Myfiles\testcase.qvd](qvd);

       

       

      FIELDS: 

      CROSSTABLE (Fieldlist, Value)

      LOAD 1 as Dummy, * 

      Resident TABLE

      where RecNo() =1; 

       

      drop Table TABLE;

      DROP FIELDS Dummy, Value; 

       

       

       

      thanks