How to compare columns between two different sheets

Rawan_Ghurab · December 1, 2022, 9:57am

How to compare all columns between two different sheets sheet1,sheet2 and keep only the similar columns in a new excel

Rahul_Unnikrishnan · December 1, 2022, 9:59am

Welcome to UiPath community…!

You can check the below video.

Thanks

RajKumar_DC · December 1, 2022, 10:03am

Hop this is help you for your request. plz check attached Xaml with attached Excel file

Thanks,

Gokul001 · December 1, 2022, 10:56am

Here you may find a lot of similar topics

Topic		Replies	Views
I want to compare two columns from two different excel and put it in second excel sheet. Please give me a solution. Thanks in advance Help	2	1055	July 30, 2019
Compare between 2 sheets Community datatable , excel , studio , question , community , uipath	6	754	December 1, 2022
How to compare data from a excel sheet with another excel sheet and highlight differences in first excel sheet row Studio excel , studio , question , activities_panel	4	884	December 25, 2021
Compare & refer data between 2 sheets Help	11	2246	March 9, 2019
I want to compare the two columns from different excel sheets ,each row has fixed names , if the row name matches with row name in another excel then we need to compare the values ,if values are not same we need to take the difference ,please help me Studio studio , question , tools	10	791	March 17, 2021