9 Replies Latest reply: Mar 17, 2015 4:33 PM by Gyanaranjan Tripathy RSS

    Applymap() not fetching all records

    Gyanaranjan Tripathy

      Hi,

      I have mapped one of the table using applymap(), but i'm getting two records out of the field and one record is getting dropped.

      MonthYear_Table:

      Mapping Load

                     Product_Desc,

                     Month_Year

      From[ ..Tablename.qvd](qvd) where country<>'ABC';

       

      Mapping Load

                     Product_Desc,

                     Prod_Category_ID

      From[ ..Tablename.qvd](qvd) where country<>'ABC';

       

      Table3:

      Load Plant,

      %PP_Key

           Month_Year,

           Prod_Category_ID,

      Prod_Name,

      Prod_Goal

      -

      -

      FROM [....Tablename.qvd](qvd)

       

       

      Table1:

      Load

      Plant&Applymap('MonthYear_Table',Product_Desc)&Applymap('MonthYear_Table',Product_Desc) as %PP_Key,

      Applymap('MonthYear_Table',Product_Desc,'0') as Month_Year,

      Applymap('MonthYear_Table',Product_Desc,'0') as Prod_Category_ID

      -

      -

      -

      FROM

      [..Table.qvd](qvd)

       

       

      Thanks,