Qlik Community

Ask a Question

App Development

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

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jigonzalez
Contributor III
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
Nicole-Smith

Add another left join to your query:

LEFT JOIN (Orders)

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

RESIDENT Orders;

jigonzalez
Contributor III
Contributor III
Author

Yes Girl. Thank You