How to check for specific condition in data table

[T_Y_Raju]

i have a data table where in i want to check column 0 condition matches with the input Variable. here in this data table i want to check the complete data table columns 0 rows
when i looping in if condition the very first row data in data column does not match and throwing business exception but it is not cheking the next row
in the new next row it has matching condition.

[Vikas_M]

Hey @T_Y_Raju ,

You can use a For Each Row in Data Table activity and inside of For Each Row in Data Table activity place a if activity
Give the condition as currentRow("Yourcolumn).Equals("YourValue/String")

It looks something like below screenshot

Hope it helps you out

[T_Y_Raju]

i have done the same but loop is not checking all the values in column 0

[T_Y_Raju]

i want all the values to checked in column 0 and if none of the values does not match then it should throw business exception

[Vikas_M]

Hello @T_Y_Raju,

Implement a try-catch activity to capture and log business exceptions. The loop will continue when u catch exception occurs.

U can surround the if activity with try catch activity

And in the catch block you can handle the exception by logging it

Such that the exception will be handled and it wont exit of the loop

[ppr (Peter Preuss)]

@T_Y_Raju

i want all the values to checked in column 0 and if none of the values does not match then it should throw business exception

we can use LINQ ALL / Any Operator

[HowTo] LINQ – First Start # Any Operator

Introduction The “Any” operator is one of the quantifier operators in LINQ used to check if at least one element of a collection satisfies a given condition or not. If the condition is satisfied for at least one item within the collection, the outcome of the Any operator is true. Otherwise, the outcome from the Any operator is false. The evaluation condition must be mandatory to return a Boolean outcome. In other words: The result of the condition has to be True or False.

API Details

<a c…

[HowTo] LINQ – First Start # All Operator

Introduction The “All” operator is a quantifier operator in LINQ used to check if each element from the collection satisfies a given condition or not. If the condition is satisfied for each element within the collection, the outcome of the operator is true. Otherwise, the outcome is false The evaluation condition must be mandatory to return a Boolean outcome. In other words: The result of the condition has to be True or False. API Details

Summary

<a class="lightbox" href="…

Assign Activity

chkResult | Boolean =
dt_FirmName.AsEnumerable().Any(Function (x) Not x(0).toString.Trim.toUpper.Equals(“MCG…”))

Here we just looked for any value which is not MCG value. So we can tell, that not all values are MCG…

Then we can use an If Activity and evaluate chkResult

Kindly note:

toUpper has to check MSGILB…