Hiii I have a problem. I use datatables.comparison from UIPATH package. It is very useful to compare 2 data tables. But there is a condition. When comparing 2 tables, only datas in the same row can be compared, and if they are in rows, they cannot be compared. Ex) NAME AGE NAME A…

Thanks for your answer! [image] I want to ask one more question! Like a pic.1, I want to find different data even some datas added on the other table. Regards,

Hi, we can also achieve it using JoinDatatable. [img20211020-3] Then, result is as the following. [img20211020-4] Filtering by Name=String.Empty will be what you need. Regards,

Can you show how to filtering by Name=string.Empty? I can’t find it myself ㅠ.ㅠ Thanks!

Hi, Can you try to use FilterDataTable activity with the following settings? [img20211020-6] Regards,

Wow It Works! I soooooo much appreciate your help! Thanks. Have a good day~ Best regards,

Hi, It’s me again [image] [image] I did exactly like u said with datas above, but my result doesn’t show Headers (NAME, AGE, NAME_1, AGE_1) like this [image] [image] How can I solve this problem?!

Hi, Can you turn on AddHeader property of WriteRange activity? Regards,

OH,my, Problem solved! Thank you Best regards,

Hi! sorry for keep bothering you. I want to color datas that I sorted. I tried to use the function ‘Countif’ in excel but it is pretty hard to use. Ex) [image] This is sorted data. [image] This is origin data that I want to color from other sheet. [image] This is result that I expect. Is th…

Data tables comparison in Excel

Help Activities

Yoichi (Yoichi) October 20, 2021, 12:15am 3

Hi,

Can you try to use JoinDataTable as the following?

The above returns the following datatable and we can easily compare both age.

img20211020-2

Can you share result you expect such as Datatable ,Dictionary etc?

Regards,

Topic		Replies	Views
Compare first column of two datatables Studio studio , question , activities_panel	9	334	September 18, 2023
How to compare two data tables and look for not matching row columns? Activities excel , activities , studio	8	2486	January 6, 2023
Compare two DTs and match each cell Studio datatable , excel , activities , question	13	2551	March 12, 2020
How To Build DataTable and Compare with another DataTable Studio	11	1772	April 24, 2020
How to compare two data tables having Name and Value pairs? Academy Feedback datatable , excel , activities , question	12	1105	June 16, 2020

Data tables comparison in Excel

Related topics