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

Help Activities
, ,
1

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)
ity.

2

Hey

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

Remove the duplicates follow this

Dt.DefaultView.ToTable(True,"ColumName","ColumnName2")

Regards,
NaNi

3

Hi, If possible pls download and see excel file.

4

Hey!

Which sheet is input and which sheet is output?

Regards,
NaNi

5

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

6

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

7

Hi @Sathish_goud_Bhurewar ,

Here we go…

Excel Join.zip (16.5 KB)

11

rethrow Activity

15

ClickActivitytry catch Activity

16

Read range Activity

17

Add datarow

18

Remove datarow

19

For each Activity

20

While Activity

21

dowhile Activity

22

For each row in datatable

23

Excel process scope

24

Check app state

25

Hover Activity

26

Send hotkey