How to check if there any duplicate data in a row from data table then output as Yes or No

[StevenIsRobotOnline (Steven)]

Hi ,
Is there a way to check if a column have duplicate values , then if it does return as YES or NO if does’nt have.

Thank you

[ppr (Peter Preuss)]

Assign Activity
hasDupsInCols | Boolean =

(From d in YourDataTableVar.AsEnumerable()
Group d by k = d("YourColName").toString.ToUpper.Trim into grp=Group
Where grp.Count > 1
Select k).Any()

[StevenIsRobotOnline (Steven)]

I Put it in decision activity , why it throw this error ya ?

thanks

[ppr (Peter Preuss)]

find updated statement above

We also would suggest that you elaborate more on your case and share some sample data with us

[Aakash_Singh_Rawat]

Hi @StevenIsRobotOnline ,

Instead x(“UNIQUE”), use d(“UNIQUE”) as you have used row variable d in “from d in dt.asenumerable…”

[StevenIsRobotOnline (Steven)]

@ppr

(From d in YourDataTableVar.AsEnumerable()
Group d by k = d("YourColName").toString.ToUpper.Trim into grp=Group
Where grp.Count > 1
Select k).Any()

its just some normal data table
and if there is any duplicate values in column B then it will return YES

[ppr (Peter Preuss)]

@StevenIsRobotOnline

and if there is any duplicate values in column B then it will return YES

we gave the statement above. When expected output is different, then we prefer sample data instead of textual statements.

[mkankatala (Mahesh Kankatala)]

Hi @StevenIsRobotOnline

=> Use the Read range workbook activity to read the excel and store in a datatable.
=> Take an assign activity and write the below LinQ query.

- Assign -> hasDuplicates As Boolean = YourDataTableVar.AsEnumerable().GroupBy(Function(row) row("ColumnName")).Any(Function(g) g.Count() > 1)

=> After assign take an If condition to check the hasDuplicates boolean value.

- Condition -> hadDuplicates = True

=> In then block give activity to return the value ‘YES’
=> In else block give activity to return the value ‘No’

Hope it helps!!