3 Replies Latest reply: Jun 24, 2013 10:01 AM by Dave Bingley RSS

    table not found

    Dave Bingley

      In the following request (of which I have created more than 100 like it) I am getting a Table Not Found error.

       

      I cannot understand this due to having done so many others without issue and not getting the error.  My understanding is that the table gets created by this very code.  I have however created a blank qvd file, to see if this works, it didnt.

       

      Any ideas?

       

      // Load Purchase Orders



      PurchOrders:

      LOAD

      PURCHID as [POrder_PURCHID],

      PURCHNAME as [POrder_PURCHNAME],

      ORDERACCOUNT as [POrder_ORDERACCOUNT],

       
      WINDOWSID as [POrder_WINDOWSID];
          

      SQL SELECT

          PURCHID,

          PURCHNAME,

          ORDERACCOUNT,

          WINDOWSID
             

      FROM SELSQLAX.DynAxLive.dbo.PURCHTABLE;


      store PurchOrders into \\sel-app-03\QlikView\Synseal\data\PurchOrders.qvd;

      Drop Table PurchOrders;