Search: add-data-column

or columns according to the logical conditions that are specified in the wizard. The body of the activity

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

Filter Data Table

filter data table.jpg

Data Table

conditions in the Filter Wizard window. The activity can keep or delete rows or columns according

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data table.jpg||class="img-thumbnail"]]>>attach:filter data table.jpg]] (* is mandatory) == **In the body

) In the body of activity Configure Connection - Set connection string, data source, data provider. Data Table - The DataTable variable that will be inserted into the Table. The DataTable columns' names and descriptions must match the ones from the database table. Table Name - The SQL table in which the data

Insert Data Table

Insert Data Table

]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Data

RCA.Activities.Core.BulkAddQueueItems Description This Bulk Add Queue Items activity enables you 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

Bulk Add Queue Items

Bulk Add Queue Items

" %) ((( RCA.Activities.Core.BulkAddQueueItems == **Description** == This Bulk Add Queue Items activity enables you to add a collection of items to a data table to a specific queue. Once it is added to the queue, the items’ status is changed

: this will add all the items if there is no error occurs. Otherwise, all items are not going to be added

the transaction which you want to add. Misc Public (Checkbox) - If you check it, the data of this activity

RCA.Activities.Core.AddTransactionItem Description This Add Transaction Item activity allows you to add an item in the queue, start the transaction, and sets the status to In Progress. It can also

Add Transaction Item

Add Transaction Item

" %) ((( RCA.Activities.Core.AddTransactionItem == **Description** == This Add Transaction Item activity allows you to add an item in the queue, start the transaction, and sets the status to In Progress. It can also be configured to add a custom

>) **- A collection of additional information about the transaction which you want to add. **Misc** * **Public

to add to Content Control Misc Public (Checkbox) - If you check it, the data of this activity

RCA.Activities.Word.SetContentControl Description This activity allows you to add content

) – Check this option if you want to add the value to all Content Controls with the same Title or Tag

" %) ((( RCA.Activities.Word.SetContentControl == **Description** == This activity allows you to add content to a specific Content Control

All Control Found (Boolean)** – Check this option if you want to add the value to all Content Controls

)* ** – The value which you want to add to Content Control **Misc** * **Public (Checkbox) ** - If you check

. 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

some fields when capturing data from the document, navigate to the Fields to Capture tab in the queue

[4] Capture Custom Table Data

Customizing Data Extract

Capturing Custom Table Data in akaBot Vision

, 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

field** == If you are missing some fields when capturing data from the document, navigate to the Fields

RCA.Activities.Core.AddQueueItem Description This activity enables you to add a new item

queue that you add to. The information is stored in the item and is used during transaction processing

(Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using

Add Queue Item

Add Queue Item

" %) ((( RCA.Activities.Core.AddQueueItem == **Description** == This activity enables you to add a new item to the queue. The status

. * **Item Information** - The additional information about the new queue that you add to. The information

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

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

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

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

Data Table

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

RCA.Activities.Core.JoinDataTables Description This activity allows you to add different data

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

Join Data Tables

join data table.jpg

Data Table

Join Data Table

" %) ((( RCA.Activities.Core.JoinDataTables == **Description** == This activity allows you to add different data from different tables using common values with each other. [[[[image:join data table.jpg||class="img-thumbnail"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set