2 Replies Latest reply: Dec 19, 2016 1:18 PM by Prasad Mundewadi RSS

    Sort and then store to QVD

    Prasad Mundewadi

      Hi

      I want to sort my data by snapshot date and then store it to QVD. There are total of 7 columns in the table.

      Here is my load script:

       

      Table1:

      Load SnapshotDate, Col1,Col2...Col6 from Table1

       

      Table2:

      Load * Resident Table1 Order by SnapshotDate desc;

       

      Store Table2 into [$(Path)QVD_name.qvd] (qvd);

       

      --------------------------------------------------------------------------------

      When I run the load it throws error as 'Table2 not found'.

      There are total of 7 columns in the table. Instead of 'Load * Resident Table1' If I list any 6 columns I don't get error. I cannot figure out why is this happening? Can somebody explain?