Search: join-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 239Activities
- 16akaBot Vision
- 8akaBot Center
- 3akaBot Insights
- 2Data Service
- … 4 more
Last author
- 60Tuan Nguyen
- 55Nga Nguyen
- 47VuNH54
- 45admin
- 39Nhan Nguyen
- … 3 more
Creator
- 177admin
- 42Tuan Nguyen
- 26Nga Nguyen
- 19Giang Tran
- 8Nhan Nguyen
- … 1 more
Last modification date
Creation date
Object type
- 2Activities
- 1Overview
- 1aka Bot Vision
Uploaded by
- 105Nga Nguyen
- 74Nhan Nguyen
- 46admin
- 43Tuan Nguyen
- 21Giang Tran
- … 3 more
Upload date
For Each Row
Located in
- Rendered document content
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 the DataRow. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security
- Location
Data Table
- Raw document content
) == **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
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before
Bulk Add Queue Items
Located in
- Rendered document content
to add a collection of items to a data table to a specific queue. Once it is added to the queue
…) - The data table that you want to add the queue into. QueueName (String) - The queue to which the new queue
…Output Result (DataTable) - This is the data table that you have added to the queue.
- Raw document content
of items to a data table to a specific queue. Once it is added to the queue, the items’ status is changed
…. The default value is: AllOrNothing * **Queue Items DataTable (DataTable)** - The data table that you want
…**Output** * **Result (DataTable) **- This is the data table that you have added to the queue
[3] Review Document
Located in
- Rendered document content
After importing the document successfully and the data extraction process is successfully finished
…, 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
- Raw document content
="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
…in each field that has been detected incorrectly [[image:image-20220420193327-2.png||data-xwiki-image
Read Range
Located in
- Rendered document content
(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
…” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
…)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole
- Raw document content
range in a data table variable. Only data table variables are supported ))) {{velocity
…: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g
…want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole
Write Range
Located in
- Rendered document content
. Only string variables and strings are supported. Data Table - The data that you want to write
…to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data
…RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
- Raw document content
and strings are supported. * **Data Table** - The data that you want to write to the specified range
…which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable
…" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable
Append Range
Located in
- Rendered document content
are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable
…in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you
- Raw document content
". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data
…and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added
…to public it. Remember to consider data security requirement before using it. * **Display Name (String
Excel Write Range
Located in
- Rendered document content
. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data
…RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from
- Raw document content
and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified
…** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable
…" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable
[4] Business dataset
Located in
- Rendered document content
in edit mode. Select Data Source. Search jhi_dataset table and drag it to the data source interface. Select a relationship with an existing table on the data source interface.
…Dataset The default columns in the Business Dataset table are Manual Time and Hourly Cost. You can also
- Location
[1] ROI data set
- Raw document content
in edit mode. 1. Select **Data Source**. 1. Search **jhi_dataset **table and drag it to the data source interface. 1. Select a relationship with an existing table on the data source interface. ))) {{velocity
…** == The default columns in the **Business Dataset** table are **Manual Time** and **Hourly Cost**. You can also
CV Table Extract
Located in
- Rendered document content
RCA.Activities.ComputerVision.CVTableExtract Description Extracts a table that is visible
…to consider data security requirement before using this property. Display Name (String) - The name
…] CV Table Extract Output Result (DataTable) - The retrieved table, stored in a DataTable variable
- Title
CV Table Extract
- Location
CV Table Extract
- Raw document content
" %) ((( RCA.Activities.ComputerVision.CVTableExtract == **Description** == Extracts a table that is visible on the screen and stores
…) **- Check if you want to public the activity. Remember to consider data security requirement before using
…to organize and structure your code better. E.g: [201135155] CV Table Extract **Output** * **Result
[05]For Each
Located in
- Rendered document content
, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable
…it, the data of this activity will be shown in the log. Be careful, consider data security before using
- Raw document content
" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables
…) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece
…. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity