Search: look-up-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
- 278Activities
- 25akaBot Center
- 18akaBot Vision
- 4Data Service
- 3akaBot Agent
- … 6 more
Last author
- 87Nga Nguyen
- 67admin
- 55Tuan Nguyen
- 44VuNH54
- 37Nhan Nguyen
- … 4 more
Creator
- 225admin
- 38Tuan Nguyen
- 35Nga Nguyen
- 26Giang Tran
- 8DatPT
- … 2 more
Last modification date
Creation date
Object type
Uploaded by
- 141Nga Nguyen
- 72admin
- 68Nhan Nguyen
- 39Tuan Nguyen
- 26Giang Tran
- … 3 more
Upload date
Build Data Table
Located in
- Rendered document content
RCA.Activities.Core.BuildDataTable Description This activity allows you to create a new Data Table with different settings. In the body of activity Data Table - Click to add/ remove columns
…Table Output Data Table (DataTable) - The Data Table variable that contains the generated table.
- Title
Build Data Table
- Attachment name
build data table.jpg
- Location
Data Table
…Build Data Table
- Raw document content
" %) ((( RCA.Activities.Core.BuildDataTable == **Description** == This activity allows you to create a new Data Table with different
…]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type
…to organize and structure your code better. **Eg**: Build Data Table **Output** * **Data Table (DataTable
Join Data Tables
Located in
- Rendered document content
Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable
…supports only DataTable variables. Data Table2 (DataTable)* - The second table that you want to use
…to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT
- Title
Join Data Tables
- Attachment name
join data table.jpg
- Location
Data Table
…Join Data Table
- Raw document content
" %) ((( RCA.Activities.Core.JoinDataTables == **Description** == This activity allows you to add different data from different tables
…"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set
…** * **Data Table1 (DataTable)*** - The first table that you want to use in the Join operation, is stored
Filter Data Table
Located in
- Rendered document content
Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports
…. Output Data table (DataTable) - the filtered Data table as an output of the activity, stored
…to consider data security requirements before using it. Display Name (String) - The name of this activity. You
- Title
Filter Data Table
- Attachment name
filter data table.jpg
- Location
Data Table
- Raw document content
.png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable
…. **Output** * **Data table (DataTable)** - the filtered Data table as an output of the activity, stored
…button so that you can access the wizard and customize your settings at any time. [[[[image:filter data
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
[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
Get Files
Located in
- Rendered document content
is unknown. E.g: 4/4/2021 9:00 AM Creation Time (To) (DateTime) – Looks for files that are created up to this date. Change to DateTime.Now to look for files up to the current run time of the bot. E.g: 4/7/2021 9
…To (DateTime) – Looks for files that have the last modification date and time up to this date. If not specified
- Raw document content
** * **Creation Time (From) (DateTime)** – Looks for files create from this date onward. Left blank if the created time is unknown. E.g: 4/4/2021 9:00 AM * **Creation Time (To) (DateTime)** – Looks for files that are created up to this date. Change to //DateTime.Now// to look for files up to the current run time
Get Queue Items
Located in
- Rendered document content
date. Output Queue Items (INumerable< QueueItem >) - This is the data table that you have added
…of transactions up to 100 from an indicated queue according to multiple filters such as creation date, priority
…it. Remember to consider data security requirements before using it. Display Name (String) - The name
- Raw document content
** * **Queue Items (INumerable< QueueItem >)** - This is the data table that you have added the queue
…data according to the reference. There are two options: ・Start with: Look for items whose references
…" %) ((( RCA.Activities.Core.GetQueueItems == **Description** == This activity allows you to retrieve a list of transactions up to 100 from
[3] Review Document
Located in
- Rendered document content
. Table TAB – move between fields in the direction from the beginning of a row to its end. UP, DOWN
…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
- 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] Design Form
Located in
- Rendered document content
Table Tabs Well Data Include components used to collect data Hidden Container Data map Data grid Edit
…choose Form tab, then click Create New button. A window will show up, user enter the name of form
…the ability to collect user data UI components are divided into 5 main groups, based on their functions
- Raw document content
|((( * HTML element * Content * Columns * Field set * Panel * Table * Tabs * Well ))) |Data|Include components
…will show up, user enter the name of form in **Name **(is required) and enter a brief description
…provide users the ability to collect user data [[image:1695034818758-663.png||height="379" width="1014
Excel LookUp Range
Located in
- Rendered document content
] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range
…. Remember to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type of value to look up into range that has been selected: Formulas, Values, Comments **Output
…. Remember to consider data security requirement before using this property. * **Display Name (String