Loop through Array, Then if statements between through two data table

Help Studio
, ,
1

Hi,

I have two arrays:

I want to loop through the larger array with 20 items in it and see which one of those items match with the smaller array that has 5 items. So my desired output would be 5 match and 15 no match.

2

@RPA_Path

Try below expression two find matching values between two arrays.

       arrMatch = arrMonthDates.Intersect(arrDataDates)
4

@RPA_Path

Try below expression.

        arrMatch = arrMonthDates.Intersect(arrDataDates).ToArray
5

@RPA_Path

Hope arrMonthDates and arrDataDates variables of type Array of String.

6

Same error as above.

And they both are system array variable

Also, I should note that the 2nd array with 5 items is from a excel data table which is converted into an array

7

@RPA_Path

I tried the same expression from my end and can’t see any error. Please find the attached screenshot for your reference.

image

8

@RPA_Path

It should be of type System.String[] but not System.Array.

9

I switched and it worked. is there any way I can log the items that didn’t match also?

1 Like
10

@RPA_Path

Yes its possible. Please try below expression.

                            arrNoMatch = arrMonthDates.Except(arrDataDates).ToArray
11

Thank you!

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.