Compare two Column

Hi Everyone,
I need to compare two column like (column1 is A, B, C, and column2 is B, D, E, C, A) when column1 “A” it will search if there is A in the column2.

Hi. I don’t understand what are you really want?

1 Like

like this
for each Activity–column 1 assign to “it”
column.contains(“it”) return true/false

1 Like

Hi
You can compare with the following steps:
For each row in Col1DataTable
Begin Loop

In your case you can modify and rewrite as

It will return true if value found else false.

End Loop

Thanks

1 Like