i have one number (i.e 12345(cell b1) in sheet1 of excel and the same number(cell b1) in different sheet(sheet2) of the same excel
i need to compare if the data in both sheets are same or not , how do i define a logic for that ?
i have one number (i.e 12345(cell b1) in sheet1 of excel and the same number(cell b1) in different sheet(sheet2) of the same excel
i need to compare if the data in both sheets are same or not , how do i define a logic for that ?
HI @poojaskyrathore you can use a excel formula
=B1=Yoursheetname!B1
And then auto fill
Regards
Sudharsan
Hi @poojaskyrathore
I am sharing a previously opened example and a link for you to follow. I hope it helps.
UiPath.Core.Activities.JoinDataTables Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the JoinType property. Properties Common DisplayName - The display name of the activity. Input…
*Mark As Solution If it is useful *
Regards,
Mohini
Happy Automation…!!!
could you be more specific with formula ?
Try this code.
You can test on more values by adding some more rows to Sheet1 and Sheet 2.
Input folder - It have input excel with 2 sheet.
Output Folder - It have output file
This is working code you can use it as it is.
LinqLeftAndRightJoin - temp.zip (10.1 KB)
Regards
Mohini
HAppy Automation…!!!
Read the data using read cell from both the sheets which gives you data in two variables then use str1.Equals(str2) which gives true or false
cheers