This Activity Perform Set Operation between two DataTable as we do in RDBMS.
1) Minus Operation: MINUS (also known as EXCEPT) returns the difference between the first and second SELECT statement. It is the one where we need to be careful which statement will be put first because we will get only those results that are in the first SELECT statement and not in the second.
This activity takes the following Input:
The Output is the Filtered DataTable.
2) INTERSECT: INTERSECT is opposite to MINUS as it returns the results that are both to be found in first and second SELECT statement.
This activity takes the following Input:
The Output is the Filtered DataTable.
3) Union: It returns a union of two select statements. It is returning unique (distinct) values of them.
This activity takes the following Input:
Output is the Filtered DataTable.
Note: Column Name Must be same in both DataTable