4 Replies Latest reply: Jun 7, 2017 1:50 AM by Anjali Ahlawat RSS

    Reports

    Anjali Ahlawat

      Hi All,

       

      I need help in one logic.

       

      I have two excels let's say A and B where I have similar data and similar columns namely :

          

      1. System Name

      2.Tags

      3.Last Communication

      4.DAT Version

      Now,column "Tags" is further subdivided as "Server and Workstation".

       

      Also,for a particular date (i.e Last Communication ) ,for server we have to take rows with 'DAT Version' from n to n-2 as one report

      and for workstation ,it should be from n to n-5.

       

      I have to club these values as one report and rest as other report.

       

      Have already tried some alternative but need some more help in completing logic for both.

      I was trying rank but it was not giving me correct results.

       

      For Example,

       

      For any particular date,

      >> Need to club the "system names" which have tags containing "Workstation" and "DAT Version" containing values n,n-1,n-2,n-3,n-4 and n-5 where n is the maximum value of "DAT Version" for that particular day.

       

       

       

      For any particular date,

      >> Need to club the "system names" which have tags containing "Server" and "DAT Version" containing values n,n-1,n-2 where n is the maximum value of "DAT Version" for that particular day.

       

      This will be my 1st report and rest of the values should fall in other report.

       

      Thanks in advance.