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.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

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

. (* is mandatory) Properties Input Destination (DataTable)* - The data table that takes the data from the source data table and handles the changes and missing schema. Source (DataTable)*- The data table to be merged with the destination data table. Misc Public (Checkbox) - Check if you want to publicize

Merge Data Table

merge data table.jpg

Data Table

Merge Data Table

data table.jpg]]>>attach:merge data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Destination (DataTable)*** - The data table that takes the data from the source data table and handles the changes and missing schema. * **Source (DataTable)***- The data table

” Selector (String)* - You can add selectors here. String supported only. Eg: Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before using it. Display

to execute. String supported only. Eg: “C:/Apps/Agent.java” * **Selector (String)*** - You can add

to public it. Remember to consider data security requirement before using it. * **Display Name (String