1 Reply Latest reply: Feb 19, 2015 6:27 AM by Anand Chouhan RSS

    Does anyone know why my applymap statement is creating multiple rows

      I have written the following but each time I apply, the system automatically creates new rows. I am sure the answer is simple here so I'd appreciate the advice. All I am looking to do is multiple the [Multiplier] by the [Gross Amount].

       

      Table_2:
      LOAD
      Country & Category as [Key Indicator],
      [Multiplier + Recovery]  as [Multiplier]

      FROM
      restricted

      TableMapping:
      Mapping
      LOAD
      [Key Indicator],
      [Multiplier]
      Resident Table_2;


      Table_1:
      LOAD
      [GROSS AMOUNT],
      [ISO] & [CATEGORY]as [Key Indicator]
      FROM
      restricted


      TestApplyMap:
      Load
      [GROSS AMOUNT],
      [Key Indicator],
      [GROSS AMOUNT]*(ApplyMap('TableMapping',[Key Indicator],'missing')) as Multiplier
      Resident Table_1;