Data tables comparison in Excel

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 AGE
Anna 28 Tom 35
Tom 32 Anna 21
Monica 27 Ross 36
Ross 31 Monica 25

It cannot be compared because each data(Age by name) you want to compare is located in different row.

Is there any way to compare two data tables that have different rows?

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,

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,

1 Like

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,

1 Like

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 there any method to get result that I expect?

Regards,

Hi,

Can you elaborate your requirement? What is your “sort”? The table rows seem not sorted in order.

Regards,

Sorry, Im bad at English

please forget about ‘sorted’ thing.

I have 4 sheet to do what we said.

image
The first sheet.
image
The second sheet.
image
The third sheet
image
The fourth sheet

If there are same data included in the 2nd and 4th sheet mutually. I want to color only same data.

Hi,

The following is rough workflow for your requirement.
(Probably need to tune in details.)

Regards,

I have the result like this.
image

I think, one different thing between your work and my work is range in Input section from Set Range Color.

How can I fix this?

Regards,

Hi,

For now, can you try to set return value of Lookup Range activity at Range property of Set Color?

Regards,

Problem solved!

You are truly Robot Master!

Thank you!!!

Regards,

1 Like