Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jigonzalez
New Contributor III

How to add an AutoNumberHash128() Key in a Table composed by a left join union

CODE EXAMPLE:

Orders:

LOAD

    OrderID,

    CustomerID,

    Office,

    OrderDate

FROM [lib://DATA COMBINADA/DATA COMBINADA.xlsx]

(ooxml, embedded labels, table is Orders);

Left join

LOAD

    OrderID,

    ProductID,

    Quantity,

    UnitPrice,

    SaleAmount

FROM [lib://DATA COMBINADA/DATA COMBINADA.xlsx]

(ooxml, embedded labels, table is OrdersDetails);

I need a Key

AutoNumberHash128(Office,ProductID) as .keyOfficeProductID

But if I put it after SaleAmount, It show me a message saying 'Field 'Office' not found'

2 Replies

Re: How to add an AutoNumberHash128() Key in a Table composed by a left join union

Add another left join to your query:

LEFT JOIN (Orders)

LOAD DISTINCT AutoNumberHash128(Office,ProductID) as .keyOfficeProductID, Office, ProductID

RESIDENT Orders;

jigonzalez
New Contributor III

Re: How to add an AutoNumberHash128() Key in a Table composed by a left join union

Yes Girl. Thank You

Community Browser