MarketplaceListingsCustom ActivityAuxiliobits - Set Operation on DataTable

Auxiliobits - Set Operation on DataTable

by Auxiliobits Technologies Pvt. Ltd.

4

27.7k

Auxiliobits - Set Operation on DataTable

by Auxiliobits Technologies Pvt. Ltd.

4

Custom Activity

27.7k

Summary

Summary


Overview

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

Features

Features


Additional Information

Additional Information

Dependencies


Code Language

C#, Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Auxiliobits Technologies Pvt. Ltd.

Visit Publisher's Page

Trusted Source

License

Apache

Technical

Version

1.0.0

Updated

03 Dec 2020

Works with

UiPath 2019.4+

Certification

Silver Certified

Tags

data
datatable
erp
processing
studio
table

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings