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

    loading fields from empty qvd

    Didier Agonvonon



      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.




      Load * FROM





      CROSSTABLE (Fieldlist, Value)

      LOAD 1 as Dummy, * 

      Resident TABLE

      where RecNo() =1; 


      drop Table TABLE;

      DROP FIELDS Dummy, Value;