Search: look-up-data-table

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

Filter Data Table

filter data table.jpg

Data Table

.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

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

Insert Data Table

Insert Data Table

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

. 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

[4] Capture Custom Table Data

Capturing Custom Table Data in akaBot Vision

Customizing Data Extract

, 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

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

** * **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

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

** * **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

. 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

="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

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

|((( * 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 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

. 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

started! If you want to give a look to the underlying XWiki Syntax, you can click on "Wiki code

of the XWiki Syntax you can use in wiki pages (headings, images, tables). Headings XWiki offers 6 levels

1 Numbered list Item Subitem Item Subitem Mixed list Item 1 Item 2 Item 3 Item 4 Item 5 Tables

}} If you want to give a look to the underlying [[XWiki Syntax>>XWiki.XWikiSyntax]], you can click on "Wiki

>>XWiki.XWikiSyntax]] you can use in wiki pages (headings, images, tables). = Headings = XWiki offers 6 levels

. Item 1 11. Item 2 11*. Item 3 11*. Item 4 1. Item 5 = Tables = You can create tables right into wiki

RCA.Activities.Excel.ExcelGetWorkbookSheets Description This activity allows you to look

to public it. Remember to consider data security requirement before using it. Display Name (String

. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string

" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheets == **Description** == This activity allows you to look for a sheet based on its index

) **- Check if you want to public it. Remember to consider data security requirement before using

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) ))) **Output** * **Sheet (List< String