Search: remove-data-row

, akaBot Vision provides users with the capability to add or remove rows in a table To insert a row, you can click "+" icon To delete a row, you can click "x" icon To add a new row at the end of the table

After importing the document successfully and the data extraction process is successfully finished

or remove rows in a table * To insert a row, you can click "+" icon * To delete a row, you can click "x

="wikigeneratedid" %) After importing the document successfully and the data extraction process is successfully

with this status in the “To review” tab in the user interface. [[image:image-20220420193327-1.png||data-xwiki

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

. E.g: "Sheet1" Starting Cell - The cell from which to start extracting the row data. By default

: "Sheet1" Starting Cell (String)* - The cell from which to start extracting the row data. By default

of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable

Excel Read Row

Excel Read Row

from which to start extracting the row data. By default, this is filled in with "A1". E.g: "A1

" * **Starting Cell (String)*** - The cell from which to start extracting the row data. By default

the values of an Excel row beginning from the cell specified in the StartingCell field: and stores

" 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

(String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1

" Starting Cell (String)* - The cell from which to start extracting the row data. By default, this is filled

RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell

Read Row

Read Row

extracting the row data. By default, this is filled in with "A1". E.g: "A1" == **Properties

(String)*** - The cell from which to start extracting the row data. By default, this is filled in with "A1

" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified

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

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

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

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

" %) ((( RCA.Activities.Core.ForEachRow == **Description** == This activity allows you to execute an action once 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