Compare 2 data and find the differences of the data

Help Studio
, ,
1

DATA (2).zip (43.5 KB)

This is the 2 excel files that needed ti be compared. one of them is annually data and another one is a quarterly data. I want to compare these 2 data and find the difference in the data

please send me the solution using UiPath

2

Hi @Ryan_Lee

Here you can try the solution below.

  • Read Range for annualData and quarterlyData.
  • Build Data Table for differenceData.
  • For Each Row in quarterlyData:
  • Filter Data Table on annualData by matching NRIC.
  • If row exists in annualData:
    • For Each Column to compare values.
    • If values differ, add row to differenceData.
  • Else add row to differenceData as “Missing in Annual Data”.
  • Write Range to output differences.

Cheers.

3

care to show me how you do it so i can refer to it better?

4

Hello @Ryan_Lee,

Can you explain more on what kind of difference in data do you need?

5

Hi @Ryan_Lee ,

Both the excel sheet1 contains 109 rows , can you explain what you want exactly?
Like comparison column name, Sample output file

Regards,
Gowtham K

6

like the anual excel file and quarterly excel file same person but in the 2 excel sheet some of the columns they are different so i would like to find if there is any difference in anual and quarterly data

7

there are difference in each column cos they are anual data and quaterly data. i want to find which data is different and put in in another variable