2 Replies Latest reply: Apr 26, 2018 5:49 PM by Jose Gonzalez RSS

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

    Jose Gonzalez

      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'