@Shubham_Bidwai Can u share input tables screenshot and also how u want the output.
If you have two different datatable you can use merge datatable and then write them in the excel file
Regards
Sudharsan
@Suraj_B_Shetty plz check once
@Shubham_Bidwai Using join data table u can achieve this.
You can use merge datatable activity it will add the data table below
or in the simplest way
First the write one table in the excel and then append range the next table in the same excel .
Regards
Sudharsan
after use append same issue is their
@Suraj_B_Shetty i already used join data table
Have you tried merge datatable ?
and also can you share those two output files here? @Shubham_Bidwai
@Shubham_Bidwai can u share output screenshot. How u want the final output?
@Shubham_Bidwai Can u share the input files here?
i used merge activity but shows error
i already share that
@Shubham_Bidwai u have shared the screenshot. Can u share the sample files which u are using?
just after merge the datatable gives all result shown but is their any activity for removing same name
@Shubham_Bidwai using linq u can remove.
dt_output=(From x In dt_output
Group x By k1=x(“Name”).ToString.Trim Into grp=Group
Select grp.First).CopyToDataTable()
Here dt_output is table which u got after merging the two table.