Add multiple datatables into single datatable

[Shyam_Pragash]

Hi

How to join multiple datatable into single datatable ?

Input Datatable:

DT_1 :

DT_2

DT_3

Expected Output:

There is no combination between above mentioned datatable… how to join the get the expected output.

i tried join and merge acitvity but i didnt get the exprected output… i thing missing logical.

Thanks
Shyam

[Anil_G (Anil Gorthi)]

@Shyam_Pragash

Try add data column activity

Dt1 as target …column as dt2.Columns("ColumnNmae")

Cheers

[sumitha_karthik]

Hai…

You can use Write Range and pass where you starts from in range

[Shyam_Pragash]

Hi @sumitha_karthik

i have list entry to type and search it.

after that i have to extract the data from the webpages
one datatable form one page and another datatable from another pages…

Thanks
Shyam

[Rahul_Unnikrishnan]

Hello @sumitha_karthik

You can use Append Range activity. You can modify the property “starting with column” as Excel.Sheet(“Sheet1”).Cell(“D1”)

Thanks