For join data table

after join two table shows this i want to join with same cell

@Shubham_Bidwai Can u share input tables screenshot and also how u want the output.

Hi @Shubham_Bidwai

If you have two different datatable you can use merge datatable and then write them in the excel file


@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 .


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.

what is the error