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?
for each Activity–column 1 assign to “it”
column.contains(“it”) return true/false
You can compare with the following steps:
For each row in Col1DataTable
In your case you can modify and rewrite as
It will return true if value found else false.