For join data table

Help Studio
, ,
1

image
image1366×768 98.1 KB

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

2

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

3

Hi @Shubham_Bidwai

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

Regards
Sudharsan

4

image
image1366×768 86.1 KB

image
image1366×768 90.4 KB

5

@Suraj_B_Shetty plz check once

6

@Shubham_Bidwai Using join data table u can achieve this.

7

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

8

after use append same issue is their

9

@Suraj_B_Shetty i already used join data table

10

Have you tried merge datatable ?

and also can you share those two output files here? @Shubham_Bidwai

11

@Shubham_Bidwai can u share output screenshot. How u want the final output?

12

@Suraj_B_Shetty

image
image1366×768 98.3 KB

13

@Shubham_Bidwai Can u share the input files here?

14

i used merge activity but shows error

15

i already share that

16

@Shubham_Bidwai u have shared the screenshot. Can u share the sample files which u are using?

17

just after merge the datatable gives all result shown but is their any activity for removing same name

18

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

19

image
image1366×768 111 KB

what is the error