I have one problem

Help AI Center
,
1

hi All
i have two excel sheet and and both sheet has one same column which is (Name),

output : i want all same to same data from sheet 1 and only un matching name data from sheet 2

plz help me for that query

thanks in advance

2

@Shubham_Bidwai

Use join datatables activity and do a left join with first table as table2 and second table as table1

Join on name

Cheers

3

@Anil_G after join activity data can not join properly

4

@Shubham_Bidwai

May I know what do you mean not joined properly?

Cheers

5

@ i will send a scrrenshot

1 Like
6

@Anil_G

image
image1366×768 79.3 KB

7

@Anil_G

image
image1366×768 92.5 KB

8

@Shubham_Bidwai

Looks liek the join is proper…after join while writing make sure to check add headers

And also if any headers are not needed use filter datatable and go to column options and give the name of those columns you need

Cheers

9

@Anil_G after join the same name write with same line but i want to write same name in one flow
after header

image
image850×568 31.3 KB

showing that arrow data in A col

10

image
image1366×768 82.4 KB

this is my join data table activity

11

@Anil_G plz

12

@Anil_G Name1,Task1 should not shown it will join with the same

13

@Shubham_Bidwai

Use filter datatable after the join and in columns give name1 and task1 and select remove

Cheers

14

@Anil_G that data i want on Name col

15

@Anil_G on i want all the data from first sheet and non matching data from second sheet with proper format

16

@Shubham_Bidwai

Can you please send a input and required output in an excel

cheers

17

@Anil_G
sheet2

image
image1366×768 78.9 KB

sheet1
image
image1366×768 87 KB

18

@Anil_G this is my input data table sheet i want to join that data and output is

image
image1366×768 90.2 KB

19

@Shubham_Bidwai

Please attach gilrs so that we can try from out end…photos cannot be ran

Cheers

20

@Anil_G sorry i didnt understand