cc4e1f9f-ee63-4465-ade4-76e04dcd5f13.png

Simplify and optimize the flow of structured data within your organization with the help of activities like data transformation, validation, comparisons. By automating these tasks, data can be streaml

Structured Data Streamlining

データ変換、検証、比較などのアクティビティを利用して、組織内の構造化データのフローを簡素化し、最適化します。これらのタスクを自動化することで、データを合理化、標準化し、アクセスしやすくすることができ、効率的なデータ分析、レポート作成、意思決定のプロセスにつながります。

自動化ツールと技術を活用して、大量のデータを管理および処理するための体系的なアプローチのメリットを活用します。手動作業を削減して

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

e66ee59e-8de3-4283-a9db-3e1b163eff7b.jpg

2f45478e-6541-4b8c-a394-531848cfc1fe.nupkg

This activity provides a more user-friendly way to compare two DataTables based on the contents of the other. The input and output are as follows.

Use cases for this activity include:

*   Filtering an Excel sheet containing information about companies based on a table extracted from a website
*   Identifying records that are common to two tables of contacts that come from different sources
*   Eliminating duplicates that occur when aggregating CSV files corresponding to different periods of time

It compares two input DataTables and outputs three new DataTables with the following characteristics:

(1) Rows that belong only to the first input DataTable

(2) Rows that are common to both input DataTables

(3) Rows that belong only to the second input DataTable.

**NOTE**: Installation Guidelines for Custom Activities can be found [here](https://dmtyylqvwgyxw.cloudfront.net/instances/214/assets/help-guides/UiPath-Go-Installation-Guide-Custom-Activities.pdf).

This activity compares two input DataTables and outputs three new DataTables

Visual Basic

90df4f3f-c0f1-4706-b6c6-716af7a62d34.zip

00164dc3-06d7-40f0-8023-7602b1555575.nupkg

This activity provides a more user-friendly way to compare two DataTables based on the following aspects: 

  

(1) Rows that belong only to the first input DataTable.

(2) Rows that are common to both input DataTables.

(3) Rows that belong only to the second input DataTable.

  

Use cases for this activity include:

*   Filtering an Excel sheet containing information about companies based on a table extracted from a website.
*   Identifying records that are common to two tables of contacts that come from different sources.
*   Eliminating duplicates that occur when aggregating CSV files corresponding to different periods of time.

This activity compares two input DataTables and outputs three new DataTables.

Version	Release Date	Download Link
2.0.0	July 20, 2021
v2.0.0 is compatible with both .NET 6 and .NET Framework 4.6.1.
1.0.8	September 21, 2018
first release

Compare DataTables