Q) Compare Two Datatable

Help Activities
, ,
1

image
image829Ă—182 3.28 KB

Hello.

Compare two data tables
I want to extract data that is not the same.

If you know how,
I ask for your help.

2

How many columns do you want to compare? Or all the columns?

If you compare two columns only, you can use activity “Join Data Tables” to check the difference and similarity. You may have to compare columns individually if you want to compare the whole datatable.

3

I’d like to compare all the columns

4

Hi,

The following will help you.

image
image760Ă—451 12.9 KB 

arrDr = dt2.AsEnumerable.Except(dt1.AsEnumerable,DataRowComparer.Default).ToArray

arrDr is DataRow[] type.

Regards,

5

Thanks,

Let me ask you one more question.

Only values that are not the same
Is there a way to extract it?

Ex) 3,3,3,4,4,4,5,5,5

6

Hi,

Only values that are not the same
Is there a way to extract it?

Can you elaborate?
Is “3,3,3,4,4,4,5,5,5” expected output?

Regards,

7

After comparing the two data tables,
You must find a location for an unequal value.

so
I want to extract only the values that are not the same, is it possible?

On the Excel screen that I uploaded as an example,
The price I want is
I want to extract only the separate values of 3, 3, 4, 4, 5, 5.

8

Hi,

How about the following expression?

image
image776Ă—522 13.7 KB 

 String.Join(",",dtResult.AsEnumerable.SelectMany(Function(r) r.ItemArray))

Regards,

9

Thank you.

I want to use Uipath freely like you, so what kind of study should I do?

10

Hi,

I think it’s better to learn by UiPath Academy, first. However, the above expression is technique of VB.net rather than UiPath. So, next learn VB.net or C# deeper. The following topic might also help you.

Regards,