Excel file, It has 3 sheets first sheet has 3 coloumns, second sheet has 4 coloumns. compare and join in 3rd sheet

Can anyone pls help on this problem.
For example: common points of both sheets first sheet has emp id 1,2,3,4,5 and 2nd sheet has emp id 1,2,3,4,5,6,7,8 Known compare both but result should be in the form of emp id should contain data 1,2,3,4,5,6,7,8.without the Coloumn em_id in the table when we use join table activ
Taskk.xlsx (11.5 KB)


Use merge data table and remove the duplicates you’ll get the expected output…

Remove the duplicates follow this



Hi, If possible pls download and see excel file.


Which sheet is input and which sheet is output?


first sheet and 2nd sheet is input, third sheet is output

You can use the Join DataTable activity
Left table: Sheet2, Right table: Sheet1 , Join type: Left Join

afterwards just remove, rearrange the join result

  • filter datatable and remove/reorder the columns
    OR JoinDataTableVar.DefaultView.ToTable(False, ArrayWithTheNeededColNames)

As an alternalte we can also use a LINQ statement

Hi @Sathish_goud_Bhurewar ,

Here we go…

Excel Join.zip (16.5 KB)

rethrow Activity

ClickActivitytry catch Activity

Read range Activity

Add datarow

Remove datarow

For each Activity

While Activity

dowhile Activity

For each row in datatable

Excel process scope

Check app state

Hover Activity

Send hotkey