Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mellerbeck
Creator II
Creator II

Mapping load with Hash128 function

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?

0 Replies