Has anybody ever used 'Column' as input property in the AddDataColumn activity?

Help
2

Hi @Athrix05,

Refer the sample workflow with sample excel file which explains how to use column property of add data column activity

Data (1).xlsx (34.2 KB)

The sample excel file has few columns, but i want to add another new column as “status”.

So first declare a variable, i have takes as status the variable type is system.data.datacolumn and the default value is new system.Data.DataColumn(“Status”,GetType(System.String) ) so we have to tell what is our column name and what is the type of that.

Now in Add datacolumn activity use this status variable in column and provide the datatable.
Sequence.xaml (7.1 KB)

3 Likes