Efficient way to check all values of an array to datatable?

[alvin.c.apostol26 (Alvin)]

Hi UiPath,

Let say I have an array of string.

example:

myArray = {“Banana”,“Apple”,“Kiwi”,“Pineapple”}

and I have an excel file that was save in a datatable below:

My goal is checking every value from the myArray variables to all rows in the datatable.

Hope this question makes sense.

Thanks!

[ppr (Peter)]

in general we can do it with All / Any

[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="…

[ppr (Peter)]

@alvin.c.apostol26

very value from the myArray variables to all rows in the datatable

maybe it can be specified more in detail on what return is needed like

true - all array values were found in any rows
true - any array value was found in any rows

a report which array value was found in which row (index) …