MarketplaceStudioActivityAuxiliobits - Set Operation on DataTable

Create your first automation in just a few minutes.Try Studio Web

Auxiliobits - Set Operation on DataTable

Auxiliobits - Set Operation on DataTable

by Auxiliobits, Inc.

4

Activity

Downloads

34.7k

back button
back button
carouselImage0
next button
next button

Summary

Summary

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

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.

  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:

  1. Primary DataTable

  2. Secondary Datatable

  3. Column Name as String

The Output is the Filtered DataTable.

  1. 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

None

Code Language

C#, Visual Basic

Runtime

Windows (.Net 5.0 or higher)

Publisher

Auxiliobits, Inc.

Visit publisher's page

Trusted Source

License & Privacy

MIT

Privacy Terms

Technical

Version

2.0.0

Updated

November 27, 2023

Works with

Studio: 22.10+

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings