1 Reply Latest reply: Jul 5, 2018 5:02 PM by Nicole Smith RSS

    Unique Values Based on ROW and Column

    Mayron Colville

      I'm looking to upload unique Values in which share the same ID and the price were unchanged from 1 week to another.

       

      Example:

       

      Data:

       

       

      IDPriceGroupUpdatedWeek
      11b3423
      12b3422
      23b3323
      23b3322
      34b3623
      35b3622
      46b2123
      46b2122
      52b2823
      54b28

      22

       

       

      Expected:

       

      IDPriceGroupUpdatedWeek
      11b123
      12b222
      34b523
      35b622
      52b923
      54b1022

       

      For Qlik Sense