Counting Pre-existing Combination of certain combination of column exist and report if missing or extra .
Results 1 to 2 of 2

Thread: Counting Pre-existing Combination of certain combination of column exist and report if missing or extra .
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Counting Pre-existing Combination of certain combination of column exist and report if missing or extra .

    I have one worksheet name measurementIdentity where I want to count preexisting combination (column D,H,I and J) for each Cell (unique value of column C) and band (Column K). from audit list result you will know which condition is preexisting and which is extra and which is missing. I have more list of combination which I will edit later after your solution.

    Thanks once again for your time. Requires asap.




    measurementIdentity.xlsx
    A B C D E F G H I J K
    Name1 Name2 Sector_Carrier Measurement_Identity Name3 Name4 Name5 measurement purpose ReportConfig MeasurementObject Band
    78001_1 0 Mobility-Intra-Freq 0 0 700
    78001_1 1 Cell-Edge-Intra-Freq-UL-CoMP-JR 1 0 700
    78001_1 11 Report-CGI 21 2 700
    78001_1 15 Automatic-Neighbor-Relation 15 0 700
    78001_1 19 Leaving-Coverage-Alarm 27 0 700
    78001_1_2 1 Cell-Edge-Intra-Freq-UL-CoMP-JR 1 1 AWS
    78001_1_2 2 Mobility-Intra-Freq 0 1 AWS
    78001_1_2 4 Below-Serving-Floor 3 1 AWS
    78001_1_2 11 Report-CGI 21 2 AWS
    78001_1_2 16 Automatic-Neighbor-Relation 15 1 AWS
    78001_1_4 1 Cell-Edge-Intra-Freq-UL-CoMP-JR 1 2 PCS
    78001_1_4 2 Mobility-Intra-Freq 0 2 PCS
    78001_1_4 4 Below-Serving-Floor 3 2 PCS



    I want to create another sheet name Auditsheet.xlsx based on above audit and it will look like below

    Auditsheet.xlsx
    Sector Carrier Audit Error
    78001_1 1.MeasuremetnIdentity 11-Measurement Purpose Report CGI-ReportConfig21-Measurement Object2 should not exist.

    2. MeasurementIdentity 0-Measurement Purpose Mobility Intra Freq-ReportConfig 0-Measurement Object0 is extra combination

    3. MeasurementIdentity 40- Measurement Purpose PcmdorTrace-ReportConfig 10-MeasurementObject 0 is missing
    Yes
    78001_1_2 Measurement Identity 22-Measureement Purpose Report CGI-RerportConfig21 -MeasurementObject 0 is missing
    78001_1_4 No

  2. #2
    New Member
    Join Date
    Nov 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Counting Pre-existing Combination of certain combination of column exist and report if missing or extra .

    Quote Originally Posted by querylal View Post
    I have one worksheet name measurementIdentity where I want to count preexisting combination (column D,H,I and J) for each Cell (unique value of column C) and band (Column K). from audit list result you will know which condition is preexisting and which is extra and which is missing. I have more list of combination which I will edit later after your solution.

    Thanks once again for your time. Requires asap.




    measurementIdentity.xlsx
    A B C D E F G H I J K
    Name1 Name2 Sector_Carrier Measurement_Identity Name3 Name4 Name5 measurement purpose ReportConfig MeasurementObject Band
    78001_1 0 Mobility-Intra-Freq 0 0 700
    78001_1 1 Cell-Edge-Intra-Freq-UL-CoMP-JR 1 0 700
    78001_1 11 Report-CGI 21 2 700
    78001_1 15 Automatic-Neighbor-Relation 15 0 700
    78001_1 19 Leaving-Coverage-Alarm 27 0 700
    78001_1_2 1 Cell-Edge-Intra-Freq-UL-CoMP-JR 1 1 AWS
    78001_1_2 2 Mobility-Intra-Freq 0 1 AWS
    78001_1_2 4 Below-Serving-Floor 3 1 AWS
    78001_1_2 11 Report-CGI 21 2 AWS
    78001_1_2 16 Automatic-Neighbor-Relation 15 1 AWS
    78001_1_4 1 Cell-Edge-Intra-Freq-UL-CoMP-JR 1 2 PCS
    78001_1_4 2 Mobility-Intra-Freq 0 2 PCS
    78001_1_4 4 Below-Serving-Floor 3 2 PCS



    I want to create another sheet name Auditsheet.xlsx based on above audit and it will look like below

    Auditsheet.xlsx
    Sector Carrier Audit Error
    78001_1 1.MeasuremetnIdentity 11-Measurement Purpose Report CGI-ReportConfig21-Measurement Object2 should not exist.

    2. MeasurementIdentity 0-Measurement Purpose Mobility Intra Freq-ReportConfig 0-Measurement Object0 is extra combination

    3. MeasurementIdentity 40- Measurement Purpose PcmdorTrace-ReportConfig 10-MeasurementObject 0 is missing
    Yes
    78001_1_2 Measurement Identity 22-Measureement Purpose Report CGI-RerportConfig21 -MeasurementObject 0 is missing
    78001_1_4 No
    Can some one please help

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •