Datatable comparison with variance 1% percent

Hi All,

I have 2 two datatables.

Table1 -

Column Name

A B C D E
2025-03-14 2354 1345 1312 3521
2025-03-15 2314 1345 1322 3431
2025-03-16 2314 1345 1332 3421
2025-03-17 2354 1345 1312 3421

Table2 -

2025-03-14 2351 1345 1312 3521
2025-03-15 2314 1245 1322 3431
2025-03-16 2314 1345 1132 3421
2025-03-17 2352 1345 1312 3421

I want compare both table and columns.

Compare table 1 and table 2

B and B variance within 1 %, need to validate both table same column values. Any one cell more than 1% i want outout entire column false.

Expected output is

B - True
C - False
D - False
E - False

Hey @AJITH_SK
I reproduced your case in UiPath Studio.
You can download and check it from here:
BlankProcess2.zip (44.8 KB)

Below is the flow:





2 Likes
  Ok, Sure. Thank you..

@AJITH_SK
Let me know if this helped solve your issue. If so, mark the solution option on my post :slight_smile:

1 Like

@AJITH_SK

go throw below thread

Happy automation!!