Map_id not found

mluz — Mon, 26 Jan 2026 16:26:21 GMT

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`;

Re: Map_id not found

Lisa_P — Thu, 28 Oct 2021 03:04:07 GMT

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;

topic Map_id not found in QlikView

Map_id not found

Re: Map_id not found