Accelerators
Partner Solutions
Professional Services
Collections
Sign In
Accelerators
Partner Solutions
Professional Services
Collections
Auxiliobits - Set Operation on DataTable
by Auxiliobits, Inc.
4
Activity
34.7k
Summary
Summary
Overview
Overview
This package consists of the following activities:
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 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:
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.
This activity takes the following Input:
1) Primary DataTable
2) Secondary Datatable
Output is the Filtered DataTable.
Note: Column Name must be the same in both DataTables.
Features
Features
This activities package solves in an easy way the problem of Set Operation like Minus, Intersect, Union on DataTable. It is also useful to filter DataTables based on Column and Remove from Primary DataTable.
Additional Information
Additional Information
Dependencies
Code Language
C#, Visual Basic
Runtime
Windows (.Net 5.0 or higher)
License & Privacy
MIT
Privacy Terms
Technical
Version
2.0.0Updated
Nov 27, 2023Works with
Studio: 22.10+
Certification
Silver Certified
Tags
studio
excel
table
datatable
processing
sheet
data
Application
Microsoft Excel
Support
UiPath Community Support
Similar Listings
