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

[Anonymous]

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]

Add another left join to your query:

LEFT JOIN (Orders)

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

RESIDENT Orders;

[Anonymous]

Yes Girl. Thank You