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
Use join datatables activity and do a left join with first table as table2 and second table as table1
Join on name
Cheers
@Anil_G after join activity data can not join properly
@ i will send a scrrenshot
1 Like
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
@Anil_G after join the same name write with same line but i want to write same name in one flow
after header
showing that arrow data in A col
@Anil_G plz
@Anil_G Name1,Task1 should not shown it will join with the same
Use filter datatable after the join and in columns give name1 and task1 and select remove
Cheers
@Anil_G that data i want on Name col
@Anil_G on i want all the data from first sheet and non matching data from second sheet with proper format
@Anil_G this is my input data table sheet i want to join that data and output is
@Anil_G sorry i didnt understand