Datatable operation to find if a value is repeating 3 times

Help
, ,
1

Hi
Can anyone guide me on how to find if a value of a column in a datatable is present 3 times or not? If the value is present 3 times the bot will perform some operation if not present 3 times it will terminate. I am new to uipath. Please guide me

Thanks

2

use this in IF condition

row(i).ToString.count(function(x) Ucase(x) = “yourvalue”)>=3

row(0) is first column …row(1) is second column…etc.,

3

HI @Ankita_Biswas_SDC_Ko

use the below linq to get the count of the matched rows then if count is 3 then perform the operation

count = Dt.Select(“[Column1]=‘text’”).Count

column 1 → column name
text → value your looking in the column

Best regards
Ajay

4

I am getting validation error in this one. Any clue why?

5

can you please provide screen shot of error please …

use this in IF condition

row(i).ToString.count(function(x) Ucase(x) = “yourvalue”)>=3

row(0) is first column …row(1) is second column…etc.,
“yourvalue”…is the value you are looking for …