3 Replies Latest reply: Jan 27, 2016 5:09 AM by Jyothish KC RSS

    Select only one first value for every id (new)

    Андрей Шепель

      Good day!

      In my source i have table:

       

        

      CityValue
      City1
      City1
      City1a
      City1s
      City1f
      City1b
      City2b
      City2f
      City2b
      City3aaa
      City3jjh

       

      Following script get only firts Value for every City:

      New:

      LOAD

      City,

      firstvalue(Value)

       

       

      FROM

      [D:\Users\40277028\Desktop\test.xlsx]

      (ooxml, embedded labels, table is Sheet1)

      Group By City;

       

      But for City1 it get missing value. I need for such rows get first value<>missing.