7 Replies Latest reply: Jun 24, 2014 6:46 AM by Sunil Chauhan RSS

    lookup() or mapping in script

      Hi guys,

       

      how can I use the mapping or lookup functions if I have in a database ID which start with letters like:

       

      Table1:

      ID,Date,Amount

      A70123,...,...,

      A70124,...

      A70125,...

      ...

      A80999,...

       

      Now I just want to make a relation the the description, which from the ID (A701*) = "OldCustomer"

       

      and selecting all ID which start with A70 is "BestCustomer"