3 Replies Latest reply: Aug 17, 2015 8:20 AM by Rajesh V RSS

    grouping in a table

      Hi All,

       

      I have teh data as given below. Need to bucket the instances.

       

       

      LocationNameDateMessage
      BangaloreB, Ananthakrishnan2015-07-0221
      BangaloreB, Ananthakrishnan2015-07-079
      BangaloreB, Ananthakrishnan2015-07-105
      BangaloreB, Ananthakrishnan2015-07-12241
      BangaloreB, Ananthakrishnan2015-07-13214
      BangaloreB, Geetha2015-07-021473
      BangaloreB, Geetha2015-07-071162
      BangaloreB, Geetha2015-07-101158
      BangaloreB, Geetha2015-07-131212
      BangaloreB,Harish2015-07-1283
      BangaloreB,Harish2015-07-1367
      BangaloreBabu, Bojanapu Dinakar2015-07-02653
      BangaloreBabu, Bojanapu Dinakar2015-07-07285
      BangaloreBabu, Bojanapu Dinakar2015-07-10268
      BangaloreBabu, Bojanapu Dinakar2015-07-13397

       

       

      Final output in table should be as given below.

       

       

      BucketBangaloreChennai
      0-600100
      600-80010
      800-100000
      1000-150004
      >150000

       

       

      Attaching my QVW file for reference