Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please help me to get following output from the data table.
Data table:
col1 Col2 Col3
A X 1
B Y 2
C Z 3
A X 2
B Y 3
Output:
Col1 Col2 Col3 Result
A X 1 Yes
B X 1 No
C X 1 No
A X 2 Yes
B X 2 No
C X 2 No
A X 3 No
B X 3 No
C X 3 No
A Y 1 No
B Y 1 No
C Y 1 No
A Y 2 No
B Y 2 Yes
C Y 2 No
A Y 3 No
B Y 3 Yes
C Y 3 No
A Z 1 No
B Z 1 No
C Z 1 No
A Z 2 No
B Z 2 No
C Z 2 No
A Z 3 No
B Z 3 No
C Z 3 Yes
Thanks a lot.