5 Replies Latest reply: Jun 13, 2017 5:33 AM by Shareen Kwan RSS

    Create new dimensions by applying filter to current dimension

    Shareen Kwan

      Hi All,

       

      I got my dataset as below:

         

      Opp_NumOPP_Line_ItemProduct FamilyCross Sell
      1111111AWWY
      1111111BAAY
      2222222AWWN
      2222222BWWN
      2222222CAAN
      3333333ABBY
      3333333BWWY
      3333333CAAY
      4444444ABBN
      5555555AAAN
      6666666ABBN

       

       

      The first 3 columns are the existing column in my data model.

      The last column (cross sell) is the column that should be calculated according to logic as below:

      if Opp_Num contains OPP_line_items with WW and also OTHER product family such as AA,BB will be considered as 'Y'...

       

      I tried to use mapping load and apply map as below:

      IF(Family="WW",OPP_NUM) as WW_OPP_NUM;

      IF(Family-="WW",OPP_NUM) as NON_WW_OPP_NUM;

       

      Mappingtable1:

      Mapping load

      OPP_NUM,

      NON_WW_OPP_NUM

       

      if( isnull(ApplyMap('mappingtable1',IOT_OPP_NUM,Null())),'N','Y') AS Cross_Sell

       

      However, the code cannot be loaded successfully.

       

      Anyone can help on this?