Find the duplicates in array

[tejaswi_nerella (Teja)]

Hi,

How do find the duplicates in an array of one-dimensional array like for example {apple, mango, Banana, apple}
now I want output will be like apple and count as well like how many times apple is repeated…

Thanks, advance

[NIVED_NAMBIAR (NIVED N)]

Hi @tejaswi_nerella
Check this link

How to find the count of each element in an array that is duplicated and print that value in output?

Sandeep, simplest way would be using a LINQ query. dict = (From item In intArray Group item By value= item Into GroupResult=Group Select GroupResult).ToDictionary(Function(x) CInt(x(0)), Function(y) CInt(y.Count)) Where dict => Dictionary(of Int32, Int32); intArray = Integer Array ( {1,2,1,1,2,3,4,5,1,1})

Regards
Nived N
Happy Automation

[tejaswi_nerella (Teja)]

@NIVED_NAMBIAR i don’t any idea how to use LINQ

[NIVED_NAMBIAR (NIVED N)]

Hi @tejaswi_nerella
U can u an assign activity for this
with left side in To section of assign activity as
dict and right side Value section as (From item In intArray
Group item By value= item Into GroupResult=Group
Select GroupResult).ToDictionary(Function(x) CInt(x(0)), Function(y) CInt(y.Count))

[tejaswi_nerella (Teja)]

@NIVED_NAMBIAR Thank you i will try

Do you have any reference workflow for this…

[Latika10011740 (Latika V N Durga Bhavani)]

Hi @tejaswi_nerella

You can check these as well,

How to Find Duplicate value in string array

Hello Folks, It’s urgent can anyone help me? it will be a great help. My question is how I can find duplicate value from my string array. here I have attached screenshot of my array . in this screenshot have only three lines. Thanks in advance, [19] Ankur

How to check if there are duplicates in a list of strings?

Hi @Madhavi What I try to do is if a new entry of username in the new row is duplicated to the other row in column “username”, Then send an email to user to change, Else continue to another task. I checked the filter datatable activity, but it seems only output “filtered DataTable variable”, not a boolean as I need. So I tried the first suggestion from you, but not sure what are “x” and “g” for dt.AsEnumerable().Select(function(x) x.Field(of String)(“username”)).GroupBy(function(x) x).Wher…

Thanks
Latika

[Aleem_Khan (crazy bot)]

its return null value please share workflow i appreciate