Datatable comparison with variance 1% percent

Help Studio
1

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

2

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:

A flowchart illustrating data manipulation using variables, assignments, and iterations over data tables in a software automation process. (Captioned by AI)
A flowchart illustrating data manipulation using variables, assignments, and iterations over data tables in a software automation process. (Captioned by AI)706×595 24.2 KB

The image shows an assignment operation in UiPath Studio, where a variable 'val2' is being assigned a double value converted from a data table cell. (Captioned by AI)
The image shows an assignment operation in UiPath Studio, where a variable 'val2' is being assigned a double value converted from a data table cell. (Captioned by AI)785×171 7.72 KB

This image shows a flowchart of a conditional logic process with assignments and checks for variance calculation and threshold determination, including breaking out of the flow if certain conditions are met. (Captioned by AI)
This image shows a flowchart of a conditional logic process with assignments and checks for variance calculation and threshold determination, including breaking out of the flow if certain conditions are met. (Captioned by AI)657×627 21.3 KB

The image depicts a workflow from a software automation platform, showcasing the assignment of a value to a dictionary and subsequent logging of the dictionary contents. (Captioned by AI)
The image depicts a workflow from a software automation platform, showcasing the assignment of a value to a dictionary and subsequent logging of the dictionary contents. (Captioned by AI)592×585 17.8 KB

This image shows a workflow in UiPath Studio with a main sequence that includes assigning values to variables and a list of defined variables with their types, scopes, and defaults, along with the output panel displaying execution results. (Captioned by AI)
This image shows a workflow in UiPath Studio with a main sequence that includes assigning values to variables and a list of defined variables with their types, scopes, and defaults, along with the output panel displaying execution results. (Captioned by AI)1182×927 47.7 KB

2 Likes
3 
  Ok, Sure. Thank you..
4

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

1 Like
5

@AJITH_SK

go throw below thread

Happy automation!!