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

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

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

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

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

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

to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2 Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add

Excel Insert Or Delete Columns

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

of columns (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet

-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 range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet

: === **1.  Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing

range (when **Shift** is //Up// or //Left//) API to delete a range of cell data (**Range**) from

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

/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheets/]] * [[Excel Insert Columns Table

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

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