5 Replies Latest reply: Dec 17, 2012 3:51 AM by Mohit Sharma RSS

    How to use order by clause while loading data from qvd

      Hi

              I m using this trick for order by.

      Maintable:

      LOAD

      filed1,

      filed2,

      field3

      from

      FROM

          netadd_from_mindate_to_tilldate.qvd(qvd);

      temp:

      NoConcatenate

      Load * resident Maintable

      order by field1, filed2 ;

      drop table Maintable;

      rename table temp to Maintable;

      store Maintableinto 'D:\reruntesting\Data\RawQvds\Maintable.qvd';

       

      But this is giving error like

      "Field not found temp:"

       

      Can anyone please tell what mistake i m doing?

       

      Thanks