Add column in datatable

Help Studio
, ,
1

i want to add column in datatable(dt)
that column will be picked from another datatable(Dtt)

2

Do you mean the column and all its data for existent matching rows?

3

Column with all data

4

if the second datatable has the same number of rows, you can first add the column to the first datatable using the activity add data column, and after, use a for each row to add the values into the new column, let me know if you need help implementing this.

5

Hi @Ananya1

Basically you need to do following things

image
image1136×487 28.2 KB

Create a variable with System.Data.DataColumn datatype - col1
Pass the index of you column like dt.Columns(index) to this variable - col1 = dt.Columns(0)
Then use add datacolumn activity and pass the column variable

Regards
Roshan

Please mark as a solution if you found this useful :slight_smile:

6

Hi, this could never work for 2 reasons:

  1. You cant assign column of a datatable to add into another, you would get an error
  2. The data would not come as well
1 Like