Add DataColumn and copy 3 columns to it

[hp321 (hp)]

Hi all,
*I’m trying to add a data column with the invoke method so that the new Column is added before a specific column. I’m getting an error.
*I’d like to assign 3 columns to the new column, wrote something like this:
dt.Columns(“NewColumn”).Expression=“Trim([FirstName] + ’ ’ + TRIM[LastName] + ’ ’ + TRIM[ID])”
Is there a better way?

Any help would be highly appreciated.
Thank you!

[supermanPunch (Arpan)]

Hi @hp321 ,

I believe the method name should be SetOrdinal, there is a typo mistake made in the Method name used.

[Shiva_Nikhil]

@hp321

you can also try with invoke code activity

dt1.Columns.Add.SetOrdinal(3)

inplace of 3 you can pass the integer value whereever the column you want toadd

[ppr (Peter)]

Please share with us the details:

• usage of the TargetObject Setting
• Parameters

ensure that the Parameters are correctly configured and the position is provided

How to add a column in-between the column in datatable

Add the Datacolumn to the datatable and use later SetOrdinal for moving it on a particular position [grafik] [grafik] e.g. 1 Adopt the variables and argument values to your specific scenario. Screenshots just illustrate the essentials

[hp321 (hp)]

You’re right @supermanPunch
Thanks. That got rid of the error in invoke method.

[hp321 (hp)]

@Shiva_Nikhil ,can you please specify the steps before and after the invoke code activity?
I’m not familiar with it…Do I need to add datacolumn before? How to specify the names of columns to be added? etc
Thanks

[Shiva_Nikhil]

@hp321

dt1.Columns.Add("ColumnName").SetOrdinal(dt1.Columns.Count-1)

or

dt1.Columns.Add("ColumnName").SetOrdinal(3)

it will add the datacolumn with the name , just replace ColumnName with the name which ever you want

No need to use add data column to add the column

[hp321 (hp)]

Thank you so much @Shiva_Nikhil

Now I have the new column and I want to copy 3 columns with a space.
I assigned the below, but getting an error:
dt.Columns(“NewColumn”).Expression=“Trim([FirstName] + ’ ’ + TRIM[LastName] + ’ ’ + TRIM[ID])”
Anyone has any ideas?
Thanks

[Shiva_Nikhil]

@hp321

dt.Columns(“NewColumn”).Expression=“Trim([FirstName] + ’ ’ + TRIM[LastName] + ’ ’ + TRIM[ID])”

dt.Columns(“NewColumn”).Expression=“Trim([FirstName]) + ’ ’ + TRIM([LastName]) + ’ ’ + TRIM([ID])”

can you try this once

[hp321 (hp)]

@Shiva_Nikhil

“Trim([FirstName]) + ’ ’ + TRIM([LastName]) + ’ ’ + TRIM([ID])”

Getting this error:

[Shiva_Nikhil]

@hp321

type the expression manully , Please dont copy and paste

Its working fine

[hp321 (hp)]

Thanks @Shiva_Nikhil
The columns were copied as expected, though the header now contains the expression[before combining the columns the header was ok]:

[hp321 (hp)]

Anyone have an idea how to resolve this?

I created a new column “Client and Payor”. wrote nicely in Excel.
Once I combined a few columns with as assign, the expression was added to the header

[supermanPunch (Arpan)]

Hi @hp321 ,

Maybe one of the ways to tackle it is using a different/new Datatable variable and assigning the value to it like below :

OutputDT = DT.AsEnumerable.CopyToDatatable

From Debug :