Set Operation like minus ,intersect, union Operation n datatable

Hello guys
One more components published on uipath Go

This activity performs a set of operations like Minus, InterSect, Union 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 :

  • Primary DataTable
  • Secondary Datatable
  • Column Name as String

The Output is the Filtered DataTable.

  1. INTERSECT: INTERSECT is the opposite of MINUS as it returns the results that are both to be found in first and second SELECT statement.

This activity takes the following Input:

  • Primary DataTable
  • Secondary Datatable
  • Column Name as String

The Output is the Filtered DataTable.

  1. Union: Returns a union of two select statements. It is returning unique (distinct) values of them.

This activity takes following Input :

  • Primary DataTable
  • Secondary Datatable

The Output is the Filtered DataTable

Note: Column Name Must be same in both DataTables.

8 Likes

@sandeep13 , great!!! . Need to check .

1 Like

Thanks @md.ahtesham
Please give your valuable feedback

3 Likes

This is great ! @sandeep13 Nïce sharing!

cheers

4 Likes

@sandeep13 - This is brilliant! I’ve been trying to sort and remove data from a complex set of data tables for quite a while now using the standard UiPath packages, Linq statements and other ‘tricks’ but nothing has achieved the results I need. The ‘Minus Operation’ activity in the package has done exactly what I need. Keep up the great work.

1 Like

Thanks @PhilDev for such a positive feedback.

2 Likes

is there any way to intersect with 2 column names?