How we can group by the Array value

naveen14
Kilo Guru

Hi All,

I was getting manager values into array format from catalog variables

For Ex:

a9fd3acf1b832010165320ebbc4bcb26,a9fd3acf1b832010165320ebbc4bcb26,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,485a38926f86c20076eca9331c3ee48f,b21fe4060f67b500059d7d4ce1050ea8,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,f01af4926f86c20076eca9331c3ee440,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,ccfbac83dbfb509018490ad4e2961942,d78e20060f67b500059d7d4ce1050ec1,dd9e60060f67b500059d7d4ce1050e93,0d8070f8dbfeb810631a3ed4e296199d,7cdfcc641bd0ac9000fd33f8cd4bcb37,4720b4460f67b500059d7d4ce1050e1a,139838abdb473c10cc19c3af29961915,3295cd7d0f9c47c0059d7d4ce1050e72,b21fe4060f67b500059d7d4ce1050ea8,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,9366780a0f67b500059d7d4ce1050e8c,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,e166780a0f67b500059d7d4ce1050e55,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,d0874b191b3fa450165320ebbc4bcb0a,438e04201bd0ac9000fd33f8cd4bcb31,bb66ce9b0f47b100059d7d4ce1050e5a,02fa70566f90920076eca9331c3ee488

From the above array string i want only unique values & count of each value duplicate

can anyone help me on this.

 

Thanks,

Naveen

 

 

1 ACCEPTED SOLUTION

Hi,

then use this

Script:

var str = 'a9fd3acf1b832010165320ebbc4bcb26,a9fd3acf1b832010165320ebbc4bcb26,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,485a38926f86c20076eca9331c3ee48f,b21fe4060f67b500059d7d4ce1050ea8,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,f01af4926f86c20076eca9331c3ee440,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,ccfbac83dbfb509018490ad4e2961942,d78e20060f67b500059d7d4ce1050ec1,dd9e60060f67b500059d7d4ce1050e93,0d8070f8dbfeb810631a3ed4e296199d,7cdfcc641bd0ac9000fd33f8cd4bcb37,4720b4460f67b500059d7d4ce1050e1a,139838abdb473c10cc19c3af29961915,3295cd7d0f9c47c0059d7d4ce1050e72,b21fe4060f67b500059d7d4ce1050ea8,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,9366780a0f67b500059d7d4ce1050e8c,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,e166780a0f67b500059d7d4ce1050e55,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,d0874b191b3fa450165320ebbc4bcb0a,438e04201bd0ac9000fd33f8cd4bcb31,bb66ce9b0f47b100059d7d4ce1050e5a,02fa70566f90920076eca9331c3ee488';

var arr = str.split(',');
var count = {};
arr.forEach(function(i) { count[i] = (count[i]||0) + 1;});

for (var key in count){
	gs.info(key + ": " + count[key]);
}

Output:

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

19 REPLIES 19

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

your requirement is to get unique or count of each value which is duplicate?

you can use ArrayUtil unique method to get unique

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

I  want count of individual manager from array list.

 

Regards,

Naveen

Hi,

then use this

Script:

var str = 'a9fd3acf1b832010165320ebbc4bcb26,a9fd3acf1b832010165320ebbc4bcb26,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,485a38926f86c20076eca9331c3ee48f,b21fe4060f67b500059d7d4ce1050ea8,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,f01af4926f86c20076eca9331c3ee440,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,ccfbac83dbfb509018490ad4e2961942,d78e20060f67b500059d7d4ce1050ec1,dd9e60060f67b500059d7d4ce1050e93,0d8070f8dbfeb810631a3ed4e296199d,7cdfcc641bd0ac9000fd33f8cd4bcb37,4720b4460f67b500059d7d4ce1050e1a,139838abdb473c10cc19c3af29961915,3295cd7d0f9c47c0059d7d4ce1050e72,b21fe4060f67b500059d7d4ce1050ea8,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,9366780a0f67b500059d7d4ce1050e8c,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,e166780a0f67b500059d7d4ce1050e55,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,d0874b191b3fa450165320ebbc4bcb0a,438e04201bd0ac9000fd33f8cd4bcb31,bb66ce9b0f47b100059d7d4ce1050e5a,02fa70566f90920076eca9331c3ee488';

var arr = str.split(',');
var count = {};
arr.forEach(function(i) { count[i] = (count[i]||0) + 1;});

for (var key in count){
	gs.info(key + ": " + count[key]);
}

Output:

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

I'm here to look for a solution to my website's issue. So, thank you to everyone in the community for their assistance.