How we can group by the Array value

naveen14 · ‎03-10-2022

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

Ankur Bawiskar · ‎03-10-2022

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:

Regards
Ankur

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

View solution in original post

naveen14 · ‎03-10-2022

Hi Ankur,

Thanks,You solution had solved my question.

Regards,

Naveen

Ankur Bawiskar · ‎03-10-2022

@naveen

Please mark my response as correct and close the thread.

Regards
Ankur

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

kamran ali1 · ‎03-10-2022

I am here that I find solution of my problem for my site. So, Thanks all community for your help

Olivia George G · ‎03-25-2022

Thanks, You solution had solved my question. for my site Pinterest video downloader

Regards,

zain akbar1 · ‎08-31-2022

I am here that find the solution to my problem for my website. So, Thanks to all community for your help