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

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

Anonymous — Thu, 26 Apr 2018 20:43:18 GMT

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'

Nicole-Smith — Thu, 26 Apr 2018 21:47:21 GMT

Add another left join to your query:

LEFT JOIN (Orders)

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

RESIDENT Orders;

Anonymous — Thu, 26 Apr 2018 21:49:05 GMT

Yes Girl. Thank You