Search: add-data-column

to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type

want to add to the specified DataTable Object. String supported only. Data Table (DataTable)* - The DataTable object in which you want to add a column. This field supports only DataTable objects. Misc

Add Data Column

add data column.jpg

Add Data Column

Data Table

of the activity to organize and structure your code better. **Eg**: Add Data Column * **Type Argument (Type

collection of the DataTable. * **Column Name (String)*** - The name of the new column you want to add

in which you want to add a column. This field supports only DataTable objects. **Misc** * **Public

RCA.Activities.Core.BuildDataTable Description This activity allows you to create a new Data Table with different settings. In the body of activity Data Table - Click to add/ remove columns, update column name/ column type Properties Misc Public (Checkbox) - Check if you want to publicize

Build Data Table

build data table.jpg

Data Table

Build Data Table

" %) ((( RCA.Activities.Core.BuildDataTable == **Description** == This activity allows you to create a new Data Table with different settings. [[[[image:build data table.jpg||class="img-thumbnail"]]>>attach:build data table.jpg]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type

RCA.Activities.Core.AddDataRow Description This activity allows you to add a Data Row

, then the ArrayRow property is ignored. Data Table (DataTable)* - The DataTable object in which you want to add

. Eg: Add Data Row

Add Data Row

add data row.jpg

Add Data Row

Data Table

is ignored. * **Data Table (DataTable)*** - The DataTable object in which you want to add a column

" %) ((( RCA.Activities.Core.AddDataRow == **Description** == This activity allows you to add a Data Row to a specified DataTable

should map to the type of its corresponding column in the DataTable. * **Data row (DataRow

is ignored. Eg: “Phone Number”. Data table (DataTable)* - The DataTable object from which the column

of the activity to organize and structure your code better. Eg: “Remove Data Column”

RCA.Activities.Core.RemoveDataColumn Description This activity allows you to remove a Data

Remove Data Column

remove data column.jpg

Remove Data Column

Data Table

" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified

Number”. * **Data table (DataTable)*** - The DataTable object from which the column is to be removed

edit the name of the activity to organize and structure your code better. Eg: “Remove Data Column

the structured text. This activity enables you to select column and row separators according to which the table

(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

(String)*** - The field that you add unstructured data to convert into a table. Only String are supported

. This activity enables you to select column and row separators according to which the table is generated. [[[[image:generate data table.jpg||class="img-thumbnail"]]>>attach:generate data table.jpg]] (* is mandatory

for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn

and String variables. Eg: “Name of targeted column” Data Column (DataColumn) - Specifying a DataColumn

and the column specified in the Target Column property category. (* is mandatory) Properties Input Lookup

Look Up Data Table

look up data table.jpg

Data Table

Look Up Data Table

in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail

to search for. This field supports only strings and String variables. Eg: “Name of column” * **Data Column

. Eg: “Name of targeted column” * **Data Column (DataColumn)** - Specifying a DataColumn variable here

: “Column name here”. Data Column (DataColumn) - The variable containing the column you want to sort

RCA.Activities.Core.SortDataTables Description This activity allows you to sort data tables in ascending or descending order, based on the values of a specified column. (* is mandatory) Properties

Sort Data Table

sort data table.jpg

Data Table

Sort Data Table

" %) ((( RCA.Activities.Core.SortDataTables == **Description** == This activity allows you to sort data tables in ascending or descending order, based on the values of a specified column. [[[[image:sort data table.jpg||class="img-thumbnail

: “Column name here”. * **Data Column (DataColumn)** - The variable containing the column you want to sort

a DataRow variable according to a specified column. (* is mandatory) In the body of activity DataTable row (DataRow)* - The DataRow object from which a value is to be retrieved. Properties Input Column

, the ColumnName and ColumnIndex properties are ignored. Column Index (Int)* - The index of the column whose value

Data Table

according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg

a value is to be retrieved. == **Properties** == **Input** * **Column (DataColumn

and ColumnIndex properties are ignored. * **Column Index (Int)*** - The index of the column whose value

or columns according to the logical conditions that are specified in the wizard. The body of the activity

. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports

Filter Data Table

filter data table.jpg

Data Table

conditions in the Filter Wizard window. The activity can keep or delete rows or columns according

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data table.jpg||class="img-thumbnail"]]>>attach:filter data table.jpg]] (* is mandatory) == **In the body

Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.

duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember

Data Table

** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity

" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table

** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public