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

Add Data Column Add Data Row Build Data Table Clear Data Table Filter Data Table For Each Row Generate Data Table Get Row Item Join Data Tables Look Up Data Table Merge Data Table Output Data Table Remove Data Column Remove Data Row Remove Duplicated Rows Sort Data Table

Data Table

%20Table/Activities/Remove%20Data%20Column/]] * [[Remove Data Row>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Remove%20Data%20Row/]] * [[Remove Duplicated Rows>>url:https

%20Data%20Column/]] * [[Add Data Row>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table

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

) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion

) - The number of rows you wish to add or remove. E.g: 1 Row Position (Int32) - The row where the insertion

whether the activity adds or removes rows. ・Add: Add rows to the document. ・Delete: Remove rows from

Excel Insert Or Delete Rows

" %) ((( RCA.Activities.Excel.ExcelInsertOrDeleteRows == **Description** == Adds or removes a specified number of rows at a certain position

of row (Int32)** - The number of rows you wish to add or remove. E.g: 1 * **Position (Int32)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet

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

RCA.Activities.Excel.ExcelRemoveDuplicatesRange Description Deletes all the rows

Excel Remove Duplicates Range

Excel Remove Duplicates Range

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

" %) ((( RCA.Activities.Excel.ExcelRemoveDuplicatesRange == **Description** == Deletes all the rows that are duplicated in a specified range

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

-package Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. Add New Sheets: Creates a new sheet inside a specified Google spreadsheet Append Row: Appends a row to an existing spreadsheet

or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. * Add New Sheets: Creates a new sheet inside a specified Google spreadsheet * Append Row: Appends a row to an existing spreadsheet. * Auto Fill Range: Fulfills the auto-fill

Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel LookUp Range Excel Read Cell Excel Read Range Excel Remove Duplicates Range Excel Save As Workbook Excel

Write Cell Excel Write Range Execute Macro Export Chart Read Column Read Range Read Row Write Cell Write

Insert Or Delete Rows>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Insert%20Or%20Delete%20Rows/]] * [[Excel Insert Rows>>url:https://docs.akabot.com/bin/view

%20Read%20Range/]] * [[Excel Remove Duplicates Range>>url:https://docs.akabot.com/bin/view/Activities