Search: remove-data-row

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

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

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

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

of the activity to organize and structure your code better. **Eg**: Remove Duplicated Rows. **Output

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

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

is to be removed. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security

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

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.AddDataRow Description This activity allows you to add a Data Row

in the DataTable. Data row (DataRow) - The DataRow object to be added to the DataTable. If this property is set

. Eg: Add Data Row

Add Data Row

add data row.jpg

Add Data Row

Data Table

" %) ((( 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

. Eg: Add Data Row ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc

Options Filter Rows Mode - Specifies whether to filter the table by keeping or removing the target rows

variable by specifying conditions in the Filter Wizard window. The activity can keep or delete rows

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

Mode** - Specifies whether to filter the table by keeping or removing the target rows. * **Select

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.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used

(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int

Excel Insert Rows

" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows

of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

" Range (String) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Properties Input

to consider data security requirement before using it. Display Name (String) - The name of this activity. You

: "Sheet1" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5

) **- Check if you want to public it. Remember to consider data security requirement before using

want to add to the specified DataTable Object. String supported only. Data Table (DataTable

Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements

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

Add Data Column

add data column.jpg

Data Table

Add Data Column

DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties

to the specified DataTable Object. String supported only. * **Data Table (DataTable)*** - The DataTable object

(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before

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

the input data as a CSV. This field only supports Boolean values (True, False). The default value is False

unstructured data to convert into a table. Only String are supported. Eg: “John | Frank | Levi” Positions

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

want to parse the input data as a CSV. This field only supports Boolean values (True, False

: “ColumnNameThatNeed”. Data Row* - The DataRow object from which a value is to be retrieved. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using

row (DataRow)* - The DataRow object from which a value is to be retrieved. Properties Input Column

Get Row Item

get row item.jpg

Data Table

Get Row Item

: “ColumnNameThatNeed”. * **Data Row*** - The DataRow object from which a value is to be retrieved. **Misc

according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg]] (* is mandatory) **In the body of activity** * **DataTable row (DataRow)*** - The DataRow object from which