Skip to main content
Question

How to compare 2 excels

B

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

    K
    Forum|alt.badge.img+1
    • KG 2311
    • Cadet | Tier 2
    • 3 replies
    • April 27, 2022

    Hi Bella,

     

    Try thisCapture4

    A
    Automation Anywhere Team
    Forum|alt.badge.img+12

    @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


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings