We were founded in 2005 in a tiny apartment in Bucharest, Romania as DeskOver.

Fittingly, it was a customer who, in 2012, first saw the immense possibilities for us in the fledgling RPA market. Our desktop automation product launched in 2013. In 2015, we introduced our enterprise platform along with our new name.

Today, UiPath is the fastest-growing enterprise software company in history with scores of offices, thousands of employees, partnerships with the world’s best consulting and BPO firms, a 500,000-strong developer community, and 5MM+ robots at work in over 5,000 global enterprises.

Our mission is to deliver the leading Robotic Process Automation platform to our clients for an automation first mindset.

We build software robots that automate repetitive processes. Our software robots take on the tedious, mind-numbing work and free people to do the more stimulating, creative work worth doing.

But no matter how much we’ve grown, one thing hasn’t changed. We’re still building a company we love to work for

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.

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.

This activity compares two input DataTables and outputs three new DataTables

このアクティビティを使用すれば、より分かりやすい方法で、2 つのデータテーブルの内容を比較できます。入力と出力は以下のとおりです。

このアクティビティの使用例は以下のとおりです。

ウェブサイトから抽出したテーブルに基づいて、企業に関する情報を含む Excel シートをフィルターする

別々のソースから入手した 2 つの連絡先テーブルに共通のレコードを特定する

別々の期間に対応する CSV ファイルを集約する際に発生する重複を除去する

2 つの入力データテーブルを比較して、以下の特性を持つ 3 つの新規データテーブルを出力します。

(1) 1 つ目の入力データテーブルのみに属する行

(2) 両方の入力データテーブルに共通する行

(3) 2 つ目の入力データテーブルのみに属する行

注: カスタムアクティビティのインストールのガイドラインは、こちらで参照できます。

このアクティビティは、2 つの入力データテーブルを比較して、3 つの新規データテーブルを出力します

Product Manager

Visual Basic

Works as it says - I've tested this activity and works as mentioned. No bugs encountered yet. I used it to compare the last 2 data tables in SAP so the robot knows when to stop scraping data.


Well working - Self explanatory UI. Easy to understand and use. Save a lot of time using this activity. Thank you for this.


Handy Activity while working in Projects, Awesome. - Interested in understanding the code, Could you provide source code?


Quickly list table differences. - It can process list differences quickly.
I was able to easily extract the difference of the previous day of the list.


 - this seems to only work if both files are the exact same. it would be nice to have the ability to match by key like the join tables wizard does.... 


It took a couple of days to make CompareDatatables on my own.
With this, it was completed in about 30 minutes.
Very simple and convenient.
Thank you very much.

 System.Exception: Job stopped with an unexpected exit code: 0xC0000005 
I got this error only for this activity. Please help

It helps me to save time.
It's really nice. Thank you very much.

Compare Datatables

Compare Datatables

Help

How To