English

Marketplace

Listings

Custom Activity

Auxiliobits - Set Operation on DataTable

Bronze Certified

Custom Activity

4 reviews

4.6k

Version:

Auxiliobits - Set Operation on DataTable

Bronze Certified

Custom Activity

4 reviews

4.6k

Summary

This activity performs a set of operations like Minus, InterSect, Union between two DataTable as we do in RDBMS

Overview

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:
1) Primary DataTable
2) secondary Datatable
3) Column Name as String
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:
1) Primary DataTable
2) Secondary Datatable
3) Column Name as String

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:
1) Primary DataTable
2) Secondary Datatable
Output is the Filtered DataTable.

Note: Column Name Must be same in both DataTable

Benefits

Published: 03 Dec 2020 | Updated: 18 Dec 2020

Auxiliobits Technologies Pvt. Ltd.

Trusted Source

License

Apache 2.0

Code Language

Visual Basic

Runtime

.NET Framework

Auxiliobits - DataTable To XML…

Custom Activity

This Custom Activity converts Datatable to a XML File.…

4 reviews

1.2k

Silver Certified

Supported by Publisher

Auxiliobits - DataTable To JSON String…

Custom Activity

This Custom Activity converts DataTable to JSON String…

5 reviews

Gold Certified

Supported by Publisher

DataTable Manipulation…

Custom Activity

The Package contains multiple activities which are used to manipulate DataTable in a more advanced way like selecting and removing particular columns and row etc..…