サインイン
はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す →
Auxiliobits - Set Operation on DataTable
作成者: Auxiliobits, Inc.
4
アクティビティ
34.7k
![[戻る] ボタン](https://marketplace.uipath.com/static/images/icons/react-slick-active/arrow_back_slick.svg){kind=icon}
![[戻る] ボタン](https://marketplace.uipath.com/static/images/icons/react-slick-active/arrow_back_slick_mobile.svg){kind=icon}
![[次へ] ボタン](https://marketplace.uipath.com/static/images/icons/react-slick-active/arrow_next_slick.svg){kind=icon}
![[次へ] ボタン](https://marketplace.uipath.com/static/images/icons/react-slick-active/arrow_next_slick_mobile.svg){kind=icon}
要約
要約
This activity performs a set of operations like Minus, InterSect, Union between two DataTable as we do in RDBMS.
概要
概要
This package consists of the following activities:
- 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.
- 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.
- Union: It returns a union of two select statements. It is returning unique (distinct) values.
This activity takes the following Input:
Primary DataTable
Secondary Datatable
Output is the Filtered DataTable.
Note: Column Name must be the same in both DataTables.
機能
機能
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.
その他の情報
その他の情報
依存関係
None
コード言語
C#, Visual Basic
ランタイム
Windows (.NET 5.0 以上)
ライセンス契約とプライバシー条項
MIT
プライバシー条項
技術情報
バージョン
2.0.0更新日
2023年11月27日対応製品
Studio: 22.10+
認定
シルバー 認定済み
アプリケーション
サポート
UiPath コミュニティ サポート
類似のコンポーネント
