Add data column to datatable and set same value to every row

[inyourgravity]

Hi, I would like to add data column to a datatable and the value for every row in that data column should equal to the same value.

Is there a way to quickly achieve it than to use for each & assign?

[PrankurJoshi]

Hi @inyourgravity

See these

Adding data to a particular column

I have an excel sheet with n number of columns. I need to add a column (say “XYZ”) to that sheet. I need to fetch the index of that column and add data to each of the rows in that column. How can I achieve this ? Kindly help.

Insert a Column into a specific position in DataTable

How can I insert a Column into a specific position in a DataTable ?

Adding Columns to a datatable

I have a workbook with 20 columns and I need to add 4 new columns at the end namely “Old Date” , “New Date” , “Match” and “Code”. The values that would go into these columns are dynamic and are stored into 4 different variables (say a,b,c and d). I run a for each row on the datatable (say Dt) and then assign the new columns as - new DataColumn = Dt.Columns.Add(“Old Date”, GetType (String), a) and similarly for the other columns using variables b,c and d. I am then writing the data table int…

These might be helpful, give it a try

Thanks,
Prankur

[inyourgravity]

Hi, so I’ve tried this

DataColumn = Dt.Columns.Add(“Col Name”, GetType(String), DateTime.toString)

and got this
Invoke workflow file: Assign : Syntax error: Missing operand after ‘18’ operator.

Have no idea what “18” is

[KarthikByggari]

Try Invoke Code instead of Assign activity.

[inyourgravity]

Not sure how do I use it?
I’m not very familiar with codes

[KarthikByggari]

In Invoke Code activity,

Place this - Dt.Columns.Add(“Col Name”, GetType(String), DateTime.toString)

That’s it.

Invoke Code

Regards,
Karthik Byggari

[PrankurJoshi]

For adding a column you can use Add Data Column activity, it is the simplest

Thanks,
Prankur

[inyourgravity]

Still getting the same error

[inyourgravity]

But After i’ve added the data column, is there a way to assign value of each row in that datacolumn to a specific value without using for each row + assign?

[PrankurJoshi]

See this sample

Main.xaml (10.0 KB)

This will show you how to add column then insert value with and without foreach

Thanks,
Prankur

[reda (Reda_Marzouk)]

Hi @inyourgravity
as mentionned in one of the answers tagged by @PrankurJoshi the syntax to add val to a specific row for a specific column is

dt1.Rows(numrow).Item(“Column”) = “Value”

Here is a xaml file to illustrate this enjoy

Main.xaml (7.6 KB)

[MAHESH1 (MAHESHKUMAR JV)]

@inyourgravity

Try to assign default value in the Add Data Column Activity.

Other Wise
Let us take the Datatable as dta
dtb= dta
Add Data Column to dta.

dta= (From p in dta.Select
        Select ( dta.Rows.Add(p.ItemArray,strValue))).ToArray.CopyToDataTbale

strValue is the value you want to assign to that column.

Regards
Mahesh