Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
Add another left join to your query:
LEFT JOIN (Orders)
LOAD DISTINCT AutoNumberHash128(Office,ProductID) as .keyOfficeProductID, Office, ProductID
RESIDENT Orders;
Yes Girl. Thank You