Add multiple datatables into single datatable

Help Studio
, ,
1

Hi

How to join multiple datatable into single datatable ?

Input Datatable:

DT_1 : image

DT_2 image

DT_3 image

Expected Output:
image

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

2

@Shyam_Pragash

Try add data column activity

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

Cheers

3

Hai…

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

4

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…

image

Thanks
Shyam

5

Hello @sumitha_karthik

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

image
image763×512 22.4 KB

Thanks