Mapping load with Hash128 function

mellerbeck — Mon, 24 Oct 2011 21:36:21 GMT

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?

topic Mapping load with Hash128 function in QlikView