How to check whether all the values in Column A is present in Column or not

Help Activities
, ,
1

Hi Team, I am Having two sets of Data Table Variable lets say one is Column A & another is Column B(Note: B has duplicate values and Blank as well). I want to Check whether all the values in the column A are present in Column B or not it can be boolean result. And If Column A has Blanks it should neglect Blanks and match only for values Present in Column A with B Column.
Scenario 1
Column A
0001
0002
0003
0004

Column B
0000
0001

0002
0008
0003
0004

For the above result i has to get True as output because all the values in Column A is matching with column B.

Scenario 2
Column A
0001
0002
0003
0004

Column B
0000
0001
0000

0001

For the above scenario it should return false as all the values in column A are not matching with column B.

2

Hi,

Hope the following helps you.

Sample20200915-2.zip (13.9 KB)

Regards,

3

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