2 Replies Latest reply: Apr 20, 2016 8:06 AM by Jonas Melo RSS

    How to using load script to filter Reporting_Code<10026 ?

    Eksa Susanto

      Hi All

       

       

      I have below code :-

       

       

      LOAD @1:13,

           @14:46,

           @106:122,

           @123:n as Reporting_Code

      FROM

      [C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_RAW\FS_.TXT]

      (fix, codepage is 1252, no eof);

       

       

      it will display Reporting_Code as below :-

       

       

      10000

      10011

      10026

      10030

       

       

      My Question is what is the script i need to add , so that it will only keep those Reporting Code less then 10026 ? So that my QV Doc will only have 2 row of record.

       

       

       

       

      Paul ( I am using my friend account as my account cannot log in )