11 Replies Latest reply: Sep 13, 2017 10:04 PM by Vijay Vira RSS

    Filter and Sort order help

    Amit Saini

      Hi Folks,

       

      Need help on below scenario:

       

      I'm having 30 thousand records like below

       

        

      PSDNumberSales
      91002 (a)12310
      91002 (c)12320
      91002 (gs)12330
      91002 12340
      91002 (ngs)12350
      91002 (pc)12360
      91002 (pgs)12370
      91002 (pngs)12380
      91002 (re)12390
      91002 (sun)123100
      91004 (a)456110
      91004 (c)456120
      91004 (gs)456130
      91004 456140
      91004 (ngs)456150
      91004 (pc)456160
      91004 (pgs)456170
      91004 (pngs)456180
      91004 (re)456190
      91004 (sun)456200
      91002123210
      91004456

      220

       

       

      and have to filter the data by PSD in such a manner that first it should show from above data e.g 91002 ,91002 (c) and 91002(pc) , so onlt the 5 digit number followed by (c) value and last (pc) value.

       

      I need to apply this filter before loading the data and once this is loaded I want Output like below:

       

       

      PSDNumberSales
      91002123210
      91002 (c)12320
      91002 (pc)12360
      91004456220
      91004 (c)456120
      91004 (pc)456160

       

       

      Note: In PSD field 5 digit number and their respective (c) and (pc) value can be random and not available always together , but we have to filter the data first and then need to show output as above.

       

      Please help how this can be possible!

       

      Thanks,

      AS