Search: sort-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
- 16akaBot Vision
- 13akaBot Center
- 4akaBot Insights
- 3Data Service
- … 4 more
Last author
- 93Nga Nguyen
- 70Tuan Nguyen
- 63VuNH54
- 59Nhan Nguyen
- 59admin
- … 3 more
Creator
- 254admin
- 67Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 9Nhan Nguyen
- … 2 more
Last modification date
Creation date
Object type
Uploaded by
- 141Nga Nguyen
- 100Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 46admin
- … 3 more
Upload date
Insert Data Table
Located in
- Rendered document content
and descriptions must match the ones from the database table. Table Name - The SQL table in which the data
…to access the database. E.g: “System.Data.SqlClient” Input Data Table (DataTable)* - The DataTable
…the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted
- Title
Insert Data Table
- Location
Insert Data Table
- Raw document content
and descriptions must match the ones from the database table. * **Table Name **- The SQL table in which the data
…” **Input** * **Data Table (DataTable)*** - The DataTable variable that will be inserted into the Table
…(String)***- The SQL table in which the data is to be inserted. E.g: “TargetedTable” **Misc** * **Public
Look Up Data Table
Located in
- Rendered document content
supports only strings and String variables. E.g: “WordIWantToSearch” Data Table (DataTable
…to organize and structure your code better. Eg: Look up the data table Output Cell Value - Optional
…for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn
- Title
Look Up Data Table
- Attachment name
look up data table.jpg
- Location
Data Table
…Look Up Data Table
- Raw document content
only strings and String variables. E.g: “WordIWantToSearch” * **Data Table (DataTable
…the data table **Output** * **Cell Value** - Optional. The value found in the cell that has the Row
…in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail
[4] Capture Custom Table Data
Located in
- Rendered document content
. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table
…A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. Adding a predefined table field If you are missing
- Title
[4] Capture Custom Table Data
- Location
Capturing Custom Table Data in akaBot Vision
…Customizing Data Extract
- Raw document content
, click [Add Field], select Data Type = “table” and then input the value you want to create a new table
…="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. == **Adding a predefined table
[6] Query Entity Records
Located in
- Rendered document content
a list of records for the selected Entity from the Data Service, according to specified filters
…supports entities imported from Data Service. Click to add filter, the Query Builder window opens Choose
…entities imported from Data Service Input Record: the ID of the record you want to retrieve from the entity
- Location
Data Service Activities
…Data Service Studio Activities
- Raw document content
Entity from the Data Service, according to specified filters. == **In the body of activity
…imported from Data Service. * Click to add filter, the Query Builder window opens ** Choose the condition
…with the activity. The property only supports entities imported from Data Service * Input Record: the ID
[4] API resources
Located in
- Rendered document content
number of the requested page size Integer False Size of a page(top) sort String False Sorting criteria
…of the requested page size Integer False Size of a page(top) sort String False Sorting criteria in the format
…form-data File multipart/form-data environmentIds form-data Array[long] application/json Response
- Raw document content
|Size of a page(top) |sort|String|False|((( Sorting criteria in the format: property(,asc|desc) Ex
…|size|Integer|False|Size of a page(top) |sort|String|False|((( Sorting criteria in the format: property
…|Parameter Type|Type|Content Type |package|form-data|File|multipart/form-data |environmentIds|form-data|Array
[1.2] API Reference
Located in
- Rendered document content
organization's data and account information. In this document, you will find an introduction to the API usage
…is processed successfully and the user can export data via calling API Export Document with input parameters
…to review documents then change it to "Confirmed" status by API Update Document Status before exporting data
- Raw document content
** == The akaBot Vision API allows you to programmatically access and manage your organization's data and account
…and the user can export data via calling API (%%)[[Export Document>>https://docs.akabot.com/bin/view/akaBot
…%20with%20RPA/API%20Automation/#H4.UpdateDocumentStatus]](% style="color:#000000" %) before exporting data
Remove Duplicated Rows
Located in
- Rendered document content
duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember
…Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.
- Location
Data Table
- Raw document content
" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table
…** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public
…** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity
[2] Add New Field for Model
Located in
- Rendered document content
and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require
…and data type for each column Step 6: Click "Save" button Table of Content
…and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button
- Raw document content
the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png
…types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage
…the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image
Get Table
Located in
- Rendered document content
of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you
…using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored
…RCA.Activities.Word.GetTable Description This activity allows you to retrieve a table from
- Title
Get Table
- Location
Get Table
- Raw document content
the data table * **Public (Checkbox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. **Output** * **Data Table (DataTable
…== **Description** == This activity allows you to retrieve a table from a Word Document and return
Excel Append Range
Located in
- Rendered document content
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body
…, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table
…." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable
…: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables
…: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable