Search: generate-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
- 391Activities
- 24akaBot Center
- 19akaBot Vision
- 5Overview
- 4Data Service
- … 6 more
Last author
- 94Nga Nguyen
- 84admin
- 70Tuan Nguyen
- 63VuNH54
- 60Nhan Nguyen
- … 4 more
Creator
- 279admin
- 68Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 11Nhan Nguyen
- … 2 more
Last modification date
Creation date
Object type
Uploaded by
- 141Nga Nguyen
- 104Nhan Nguyen
- 72Giang Tran
- 64admin
- 55Tuan Nguyen
- … 3 more
Upload date
Extract Structured Data (NB)
Located in
- Rendered document content
(milliseconds). E.g: 30000 Output Result (Data Table) - The outputted data with type = ‘DataTable’. Not allow
…RCA.Activities.NativeBrowser.ExtractStructuredData Description The Extract Structured Data allows you to extract structured data from a specified webpage. (*For mandatory) In the body of activity
- Title
Extract Structured Data (NB)
- Location
Extract Structured Data (NB)
- Raw document content
(Data Table)** - The outputted data with type = ‘DataTable’. Not allow white space in output’s name
…" %) ((( RCA.Activities.NativeBrowser.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from
…** == * **Pick target element*** - Chooses the element to verify its existence. This activity will generate
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
Write CSV File
Located in
- Rendered document content
the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable
…\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log
- Raw document content
** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file
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
Remove Data Row
Located in
- Rendered document content
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
- Title
Remove Data Row
- Attachment name
remove data row.jpg
- Location
Data Table
…Remove Data Row
- Raw document content
" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified DataTable. [[image:remove data row.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable
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