Search: remove-data-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

)* - A DataColumn object to be removed from the column collection of the DataTable. If this property is set

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

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

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

RCA.Activities.Core.RemoveDuplicatedRows Description This activity allows you to remove duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable

Remove Duplicated Rows

remove duplicate rows.jpg

Data Table

Remove Duplicated Rows

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

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

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

. Select Columns Mode – Specifies whether to filter the table by keeping or removing the target columns

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

Filter Data Table

filter data table.jpg

Data Table

Columns Mode** – Specifies whether to filter the table by keeping or removing the target columns

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

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

is to be removed. Data Table (DataTable)* - The DataTable object from which the row is removed. Row Index (Int

can edit the name of the activity to organize and structure your code better. Eg: Remove data row.

Remove Data Row

remove data row.jpg

Remove Data Row

Data Table

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

** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable

edit the name of the activity to organize and structure your code better. Eg: Remove data row

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

to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object that is to be appended to the column collection of the DataTable. Column Name (String)* - The name of the new column you

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

DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties** == **Input** * **Column (DataColumn)*** - A DataColumn object that is to be appended to the column

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

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

. 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

) - blocks the process from continuing the execution. **Fixed formatting options** * **Column Sizes