Search: merge-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
- 388Activities
- 17akaBot Vision
- 12akaBot Center
- 4akaBot Insights
- 3Data Service
- … 4 more
Last author
- 93Nga Nguyen
- 70Tuan Nguyen
- 63VuNH54
- 60admin
- 59Nhan Nguyen
- … 3 more
Creator
- 253admin
- 68Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 10Nhan Nguyen
- … 2 more
Last modification date
Creation date
Object type
Uploaded by
- 141Nga Nguyen
- 101Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 46admin
- … 3 more
Upload date
[6] Customize Data Extract
Located in
- Rendered document content
Automation of Fields Capture Custom Table Data Configure Automation Type for Pipeline Configure Fields for Data Extraction
- Title
[6] Customize Data Extract
- Location
Customizing Data Extract
- Raw document content
* [[Automation of Fields>>path:/bin/view/akaBot%20Vision/Customizing%20Data%20Extract/Automation%20of%20Fields%20in%20akaBot%20Vision/]] * [[Capture Custom Table Data>>path:/bin/view/akaBot%20Vision
…/Configure%20Automation%20Type%20for%20Pipeline%20/]] * [[Configure Fields for Data Extraction>>path:/bin
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
Activities
Located in
- Rendered document content
Database Connect Database Disconnect Database Transaction Execute Non Query Execute Query Insert Data Table
- Raw document content
/view/Activities/Database/Activities/Execute%20Query/]] * [[Insert Data Table>>url:https
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
[1] Overview
Located in
- Rendered document content
status). Find that all the extracted data is ok, they can click Confirm button then this document
…. If the pipeline's setting is turning on Auto Split button, the documents which are merged from multiple documents
- Raw document content
to the Postponed tab (Switching to Postponed status). * Find that all the extracted data is ok, they can click
…. If the pipeline's setting is turning on Auto Split button, the documents which are merged from multiple documents
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