5 Replies Latest reply: Oct 9, 2012 2:27 PM by Stefan Wühl RSS

    Applymap

    Hardik Gandhi

      Hi,

       

      I am using applymap with string field (Customer Name):

       

      CUST_NAME_MAP:

      Mapping Load

      upper(trim(firstname)) as First_NAME,

      'YES'

      from

      Customer.qvd

      (qvd);

       

      Customer_New:

      Load

      Customer Alt ID,

      upper(trim(FIRST_NAME)) as FIRST_NAME,

      ApplyMap('CUST_NAME_MAP',upper(trim(FIRST_NAME)),'NO') as CUST_MEM_FLAG,

      from

      Customer_new.qvd

      (qvd);

       

      Its giving incorrect output.

       

      Thanks,

      H