2 Replies Latest reply on Aug 7, 2018 3:54 AM by suman kumar

    Finding First and Last value

    Kishore Kolla

      Hi,

       

      I have below data set and want to display first and last value in same date partition.

        

      DateValue
      8/7/2018Abc1
      8/7/2018Abc2
      8/7/2018Abc3
      8/7/2018Abc4
      8/8/2018Def1
      8/8/2018Def2
      8/8/2018Def3
      8/9/2018Ghi1
      8/9/2018Ghi2
      8/10/2018Tyu1
      8/10/2018Tyu2
      8/10/2018Tyu3
      8/10/2018Tyu4

       

      Output should be like below.

        

      DateValue
      8/7/2018Abc1
      8/7/2018Abc4
      8/8/2018Def1
      8/8/2018Def3
      8/9/2018Ghi1
      8/9/2018Ghi2
      8/10/2018Tyu1
      8/10/2018Tyu4

       

      Thanks

      Kishore K