I'm trying
Item_List:
Mapping LOAD
Hash128("Item No","Pack Code") as ItemNo_PackCode_Key,
"Item Net Weight"
;
SQL SELECT *
FROM [dbo].[Qlikview_ItemTable];
InventoryStockStatus:
LOAD
ApplyMap('Item_List', Hash128(Item,PackCode), 0) as "Item Net Weight"
,Item
FROM
(qvd);
But it doesn't seem to like it, if I instead use say an "Item No" & ':' & "Pack Code" it works just fine
Anyone ever use a mapping load with the hash, am I missing something?