5 Replies Latest reply: Jul 2, 2014 10:34 AM by Nayan Lalla RSS

    loading certain fields from an existing table

    Nayan Lalla

      Hi

       

      We have a consolidated model that pulls info from different QVD's .  Here is a script extract of the script

       

      LOAD DISTINCT *
      FROM
      [..\QVD\Jhb - ELSDAT\*.qvd]
      (qvd); 

       

       

      LOAD DISTINCT *
      FROM
      [..\QVD\Jhb - ELSDAT\*.qvd]
      (qvd); 

       

      Within these QVD there are many tables , however i only want to bring in is a table called "Transactions".  In this table it contains many fields but i only want three fields, which are

      • Sales Quantity
      • MonthIndex
      • Item Code

       

      I am struggling to get the above right.  Here is my scripting below. 

      LOAD

       

      [Sales Qty],
      [MonthIndex],
      [Item Code FM]
      Resident Transactions;
      DROP TABLE Transactions;
      FROM
      [..\QVD\Jhb - ELLDAT\*.qvd]

      (qvd);

       

      Wre am i going wrong?  After "DROP TABLE Transactions" everything is underlined in red.

       

      Thank you

       

      kind regards

      Nayan