Search: add-data-row

RCA.Activities.Core.AddDataRow Description This activity allows you to add a Data Row

. Eg: Add Data Row

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

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

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

should map to the type of its corresponding column in the DataTable. * **Data row (DataRow

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

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

RCA.Activities.Core.RemoveDataRow Description This activity allows you to remove a Data Row to a specified DataTable. (* is mandatory) Properties Input Data Row (DataRow)* - The DataRow object which is to be removed. Data Table (DataTable)* - The DataTable object from which the row is removed. Row Index (Int

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

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

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

RCA.Activities.Core.AddDataColumn Description This activity allows you to add a DataColumn

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

" %) ((( RCA.Activities.Core.AddDataColumn == **Description** == This activity allows you to add a DataColumn to a specified DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties

-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

: === **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 rows from a specified sheet. * Add New Sheets: Creates a new sheet inside a specified Google

for each row in a specified DataTable variable. (* is mandatory) In the body of activity Foreach - Set loop variable name in - Data table to loop Body - Add activities that you want to execute in loop Properties Input Data Table (DataTable)* - The DataColumn object whose value is to be retrieved from

For Each Row

for each row.jpg

Data Table

For Each Row

) == **In the body of activity** == **Foreach** - Set loop variable name **in** - Data table to loop **Body **- Add activities that you want to execute in loop == **Properties** == **Input** * **Data Table

" %) ((( RCA.Activities.Core.ForEachRow == **Description** == This activity allows you to execute an action once for each row

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

separator. This field supports only String variables. Input Input (String)* - The field that you add

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

This page details the Task (Job), Workflow, Queue, and Robot (Agent) data that Insights ingests

belongs to. Agent Id The row ID of the Agent that executed the job. Job Id The row ID

for job execution. Workflow ID The row ID of the workflow. OU ID The row ID of the organization

Insights data model

Insight data model

(Job),** **Workflow, Queue**, and **Robot (Agent)** data that Insights ingests. == **Task

" %)((( The row ID of the Agent that executed the job. ))) |(% style="width:242px" %)((( Job Id )))|(% style="width:890px" %)((( The row ID of the job event in the Center database ))) |(% style="width:242px

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 Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports

Filter Data Table

filter data table.jpg

Data Table

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 table.jpg||class="img-thumbnail"]]>>attach:filter data table.jpg]] (* is mandatory) == **In the body

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

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

Remove Duplicated Rows

Data Table

" %) ((( 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 (Checkbox) **- Check if you want to publicize it. Remember to consider data security requirements before