10 Replies Latest reply: Mar 20, 2013 1:06 PM by Stuart Wenzel RSS

    Exclude data from load

    Stuart Wenzel
      I cannot figure out how to exclude names containing 'coach'.
       Demographic:
      LOAD 
           1 as Counter, 
           LEGAL_NAME
      FROM Census.txt
      (txt, codepage is 1252, embedded labels, delimiter is ',', msq)
      WHERE LEGAL_NAME <> '*coach*';