Does anyone know why my applymap statement is creating multiple rows

[#1]

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;

[its_anandrjs]

After loading table drop previous table that is the error seems.

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

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

Drop Table Table_2;

Regards

Anand