2 Replies Latest reply: Oct 18, 2013 4:31 AM by Deepak Shrivastava RSS

    define default value in applymap/mapping load

    Deepak Shrivastava

      Hi all,

       

      I am trying to do something like this.

      MapCustomerTable:

       

      Mapping Load

      KeyField,

      CustName

      from Customer.xls;

       

      TransactionTable:

      Load

      KeyField1,

      Applymap('MapCustomerTable',KeyField) as CustName

      from.....;

       

      I am getting the right output in some place. But when Keyfield1 is not matching to KeyField, It returns the KeyField1 Instead of null or a CustName.

      How can I set default value if some of the key field of main table do not match the key field of Mapping table.