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

digi tal · ‎09-03-2022

thank you so much I found a solution for my website here

Laverne Fahey · ‎09-16-2022

Thank you very much! It helped me fix my site Pinterest video Downloader

Top News of the · ‎09-22-2022

The Site is good if you find What you are looking for.

Azgar · ‎10-07-2022

if you need a script format than you visit this website

mubasharzong975 · ‎10-15-2022

Thank you for the best solution site