Map_id not found

[mluz]

I tried Applymap but getting an error:   map_id not found

Can anyone help me on this one. Thanks in Advance

UnitCost_Map:
LOAD ProductID,UnitCost;
SQL SELECT *
FROM Products;

//****************ORDERS DETAILS TABLE******************//
OrderDetails:

LOAD Discount,
LineNo,
OrderID,
ProductID,
UnitPrice,
ProductID AS ContadorRegistrosIDProducto,
autonumber(OrderID &'-'& LineNo) as OrderLineKey,
Quantity,
UnitPrice *Quantity*(1-Discount)AS LineSalesAmount,
applymap('UnitCost_Map', ProductID, '0')* Quantity AS CostOfGoodsSold;

SQL SELECT *
FROM `Order Details`;

[Lisa_P · Accepted solution]

You need to put the Mapping prefix before the load statement for the mapping table.

UnitCost_Map:
Mapping LOAD ProductID,UnitCost;
SQL SELECT *
FROM Products;