Add column to data table from other data table

[yuvaraja]

HI All,

I have a datatable A with one column ‘Incident Id’ and other datatable B with status , how can i add both columns into a single data table. Pls suggest.

[lakshman (Ganta lakshman)]

Hi Yuvaraja,

By using write range activity, you can merge them into a single data table.

[yuvaraja]

Thanks Lakshman, But I guess with this we can write only into excel and again we have to read it to get those into single data table. It would be nice if I can able to do this without reading/writing from excel.

[sreekanth]

Refer this @yuvaraja

How to add a column into new datatablefrom existing datatable?

Hi, Thank you for your support. I would like to add a few question. 1.Can we add blank column? I would like to make Datatable such as, -New Datatable Column1 | Column2 | Column3 Col3 data | | Col2 data of existing DT| blank | of existing Can we use the column number insted of column name? Best Regards, Takuya

[yuvaraja]

Thanks @sreekanth will refer this.

[yuvaraja]

HI @aksh1yadav i tried this already but this is giving data like this only, it adds up the values in one column alone,

Incident_id,Status
1,
2,
,open
,completed

[aksh1yadav (AKSHAY YADAV)]

Hey @yuvaraja

Sorry …My bad…

Check it out the attached sample - Datatable Merge WIth Different Schema.xaml (14.7 KB)

Regards…!!
Aksh

[heynow]

I like invoke code, here is simple solution.

Dim i As Int32
dt1.Columns.Add(dt2.Columns(columnName).ColumnName,dt2.Columns(columnName).DataType)
For i=0 To dt1.Rows.Count-1
dt1.Rows(i).Item(columnName) = dt2.Rows(i).Item(columnName)
Next i

[yuvaraja]

Thanks @aksh1yadav , this method works well.

[yuvaraja]

Thanks @heynow will check this method as well.