Compare between 2 sheets

Help Community
, , , , ,
1

I have two sheets that I will compare between them then create a new sheet for the result
requirements :
If values in sheet1 exist in sheet2, and values in sheet2 exist in sheet1, create a new column in the result sheet call it Result then assign it to “Match”
otherwise, return the new values in sheet2 that are not in sheet1 to the result sheet with “UnMatch” and remove values that are in sheet1 and not in sheet2.

2

Hi @kalmajhad,

What about below workflow. Check Xaml with attached Excel File

kalmajhad.xaml (11.0 KB)

Xaml
kalmajhad.xaml (11.0 KB)

Ecxel
Master.xlsx (10.2 KB)

Output
image

Best,
Rajkumar

3

Thank u !
That’s my desired answer but could u please share a screenshot from the workflow because the attached XAML doesn’t work

5

Hi @kalmajhad,

Kindly find Workflow

image
image433×635 20.4 KB

image

6

Can you please give me the full expression in the assign and add data row activities

7

Hi @kalmajhad

Welcome to UiPath community

check out the video link

Regards
Gokul

8

Hello @kalmajhad

Welcome to UiPath community…!

You can check the below video.

Thanks