Question

How to compare 2 excels

  • 27 April 2022
  • 2 replies
  • 38 views

Hi all.

I have 2 Excels both containing Employee, Department, and salary. I want to compare the first excel with the second excel and if the first excel contains data/row which is already present in the second excel then I have to remove this data/row and write a fresh excel which doesn't have duplicated data from the second excel.

For eg

Excel 1

Emp Dept salary

101 IT​ 6000

102 IT 5000

103 IT 4000

Excel 2​

Emp Dept salary

101 IT​ 6000

105 IT 8000

106 IT 9000

Please help!​

Excel 3 should contain

Emp Dept salary

102 IT 5000

103 IT 4000


2 replies

Badge +1

Hi Bella,

 

Try thisCapture4

Userlevel 4
Badge +8

@Isaa Bella​ :

 

if you are still facing an issue then please create a support case

 

How to create a support case :

https://apeople.automationanywhere.com/s/article/How-to-create-a-support-case-in-service-cloud

 

if you don't have access to the above link, email the AA Support team "apeopleopsteam@automationanywhere.com" to get access.

Reply