1 Reply Latest reply: Jul 9, 2014 4:18 PM by Kevin Bertsch RSS

    Partial Reload - exact syntax

      I have a file with the following code:

       

      LOAD

      ADD LOAD

      $(vMapExpr(KEYWORDS)) as MSRREFNO,

      $(vMapTwo(KEYWORDS)) AS WILDWORD,

      NUM(LEFT(HSCODE,8)) AS D8HS,

      NUM(LEFT(HSCODE,8)) AS HSDUTY8,

      NUM(LEFT(HSCODE,6)) AS D6HS, *;

      RECORDS:

      SQL SELECT

      //TOP 10000//use this line when you want a fast reload to test new data or formula

      RECORDID,

      BN,

      LINEID,

      et

      etc.

      but this just adds all the old records on top of the existing ones. The manual is no help, since as usual, the examples are incomplete. Can someone please show the EXACT syntax for a LOAD statement followed by a SQL SELECT?