Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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;

Anonymous
Not applicable
Author

Yes Girl. Thank You