Add Column Headers to Existing Datatable

[poojan.shah1]

I have one datatable which contains only headers for my table (like Country, Sales, target etc.)

And I have another datatable which has the table values for the given colum headers(like India, 5000rs, 6000rs etc.)

I want to combine this two datatables into one so I can get Column headers for the values of existing table with values.

I tried using merge datatable activity but the column headers are not above the values instead the are aside the values table and not over them.

Please Help, Thankyou!
(find the images attached below of expected output)

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @poojan.shah1 ,
Can you share your file input and expect output?
by image pls
I think can use append range or write with no header to original
regards,

[oyvind.restad (Øyvind Restad)]

How about this?
The first “read range” has the option AddHeaders.
The assigns in the “For Each”:
ValuesDT.Columns(ColumnNumber).ColumnName = Column.ColumnName
ColumnNumber = ColumnNumber + 1

[Shiva_Nikhil]

@poojan.shah1

Hi

Try with append range activity

Use excel application scope inside use read range activity for reading the data which has data

Below read range use append range activity and pass the read range output

This will work if the two sheets are in same excel file.

Cheers

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @poojan.shah1 ,
I created the similar you
input/output

my code
WithoutHeader.zip (61.9 KB)
regards,

[Anil_G (Anil Gorthi)]

@poojan.shah1

Just use write range with add headers option unchecked and range as A2 or append range also should do

Cheers