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
- 389Activities
- 17akaBot Vision
- 12akaBot Center
- 4akaBot Insights
- 3Data Service
- … 4 more
Last author
- 93Nga Nguyen
- 70Tuan Nguyen
- 63VuNH54
- 61admin
- 59Nhan Nguyen
- … 3 more
Creator
- 255admin
- 68Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 9Nhan Nguyen
- … 2 more
Last modification date
Creation date
Uploaded by
- 141Nga Nguyen
- 101Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 46admin
- … 3 more
Upload date
Append CSV File
Located in
- Rendered document content
of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable
- Raw document content
of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append
…\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV
…)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security
[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
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