4 Replies Latest reply: Mar 7, 2014 3:11 AM by Ahyel Libunao RSS

    Script on how to get data by first four number?

      Hi,

       

      Can someone help me on how to do the script for the query below?

       

      Data Sample:

       

      Clearing Doc     Doc number

      20001234          50029384

      15002472          50028462

      20009009          50029847

      15001111          50048292

      20008302          50092842

       

      Query: If Clearing doc starts with 2000, then clearing doc = Payment Run, otherwise, Manual Check, (count doc number)

       

      Thank you

       

      - Ahyel