Search: output-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
- 239Activities
- 16akaBot Vision
- 12akaBot Center
- 3akaBot Insights
- 2Data Service
- … 5 more
Last author
- 60Tuan Nguyen
- 55Nga Nguyen
- 51admin
- 47VuNH54
- 39Nhan Nguyen
- … 3 more
Creator
- 183admin
- 42Tuan Nguyen
- 26Nga Nguyen
- 19Giang Tran
- 8Nhan Nguyen
- … 1 more
Last modification date
Creation date
Object type
- 2Activities
- 1Overview
- 1Rights
- 1aka Bot Center
- 1aka Bot Vision
Uploaded by
- 105Nga Nguyen
- 73Nhan Nguyen
- 52admin
- 43Tuan Nguyen
- 21Giang Tran
- … 3 more
Upload date
Join Data Tables
Located in
- Rendered document content
/FULL. Output Output Data Table (DataTable) - The output in the type of DataTable.
…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
- Title
Join Data Tables
- Attachment name
join data table.jpg
- Location
Data Table
…Join Data Table
- Raw document content
Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output Data Table
…" %) ((( 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
Filter Data Table
Located in
- Rendered document content
. Output Data table (DataTable) - the filtered Data table as an output of the activity, stored
…. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports
- Title
Filter Data Table
- Attachment name
filter data table.jpg
- Location
Data Table
- Raw document content
. **Output** * **Data table (DataTable)** - the filtered Data table as an output of the activity, stored
….png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable
…button so that you can access the wizard and customize your settings at any time. [[[[image:filter data
Get Table
Located in
- Rendered document content
using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored
…of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you
…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
Execute Query
Located in
- Rendered document content
in the SQL parameter. ・TableDirect - Invokes all records from a table. Output Data Table (DataTable
…Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command
…to consider data security requirement before using it. Display Name (String) - The name of this activity. You
- Raw document content
in the SQL parameter. ・TableDirect - Invokes all records from a table. **Output** * **Data Table (DataTable
…connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities
…to consider data security requirement before using it. * **Display Name (String)** - The name of this activity
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
to organize and structure your code better. Eg: Insert Data Table **Output** * **Affected Records (Int32
…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
Bulk Add Queue Items
Located in
- Rendered document content
Output Result (DataTable) - This is the data table that you have added to the queue.
…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
- Raw document content
**Output** * **Result (DataTable) **- This is the data table that you have added to the queue
…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
Get Queue Items
Located in
- Rendered document content
date. Output Queue Items (INumerable< QueueItem >) - This is the data table that you have added
…it. Remember to consider data security requirements before using it. Display Name (String) - The name
…. Integers variables supported only. Reference Filter Strategy (DropDownlist) - You can filter data
- Raw document content
value is: New. * **To (DateTime) **- Filters transaction by the maximum creation date. **Output** * **Queue Items (INumerable< QueueItem >)** - This is the data table that you have added the queue
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before
[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
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
is cleared **Output** * **DataTable (DataTable)** - Stores the data extracted from the specified Excel 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
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