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

seeqi
Giga Contributor

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

livia909
Kilo Contributor

I just found solution of my issue on my website. Thank you so much 
Regards: King of Kicks

sayra679857
Kilo Contributor

I also face some problem's but this problem handle by my professor. I am a blogger and write articles on <a href="https://paintballmaskusa.com/">good paintball masks</a>.

jhone saim09
Kilo Contributor

What does Bariatric Surgery do to Regain your Self-Esteem?

Bariatric surgery can be life-changing for the ones who want to lose weight. It is done to lose excess weight and reduce the risk of potentially life-threatening weight-related health problems. Hence, there are different bariatric surgeries, such as gastric bypass, sleeve gastrectomy, etc. Moreover, Best Surgeon in Lahore abroad is the latest trend to lose excess weight. So, with bariatric surgery, people achieve significant and sustained weight loss options. Let’s explore some benefits of bariatric surgery, helping people regain self-esteem and confidence.

blogchamp01
Kilo Contributor

I' am looking for solution of my site issue, So, thanks and appreciation for everyone in community.