Search: get-data-from-clipboard

from continuing the execution. Misc 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. Display Name (String) - The name

or characters from a file and then store it in a String variable. Properties Common Continue On Error

== **Description** == This activity allows to read all or specified context or characters from a file

(default): blocks the process from continuing the execution. **Misc** * **Public (Checkbox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before

) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command to be executed. This field must be completed according to the selection from the CommandType property. E.g: “DELETE * FROM ContactList” Properties Common Continue On Error (Boolean

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

Query** - SQL command to be executed. This field must be completed according to the selection from

Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.

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

Data Table

** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity

" %) ((( 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

RCA.Activities.Core.RemoveDataRow Description This activity allows you to remove a Data Row to a specified DataTable. (* is mandatory) Properties Input Data Row (DataRow)* - The DataRow object which is to be removed. Data Table (DataTable)* - The DataTable object from which the row is removed. Row Index (Int

Remove Data Row

remove data row.jpg

Data Table

Remove Data Row

" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified DataTable. [[image:remove data row.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable

. (* is mandatory) Properties Input Destination (DataTable)* - The data table that takes the data from the source data table and handles the changes and missing schema. Source (DataTable)*- The data table to be merged with the destination data table. Misc Public (Checkbox) - Check if you want to publicize

Merge Data Table

merge data table.jpg

Data Table

Merge Data Table

data table.jpg]]>>attach:merge data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Destination (DataTable)*** - The data table that takes the data from the source data table and handles the changes and missing schema. * **Source (DataTable)***- The data table

some fields when capturing data from the document, navigate to the Fields to Capture tab in the queue settings. In this tab, you can manage pre-trained data fields and select which of them should be extracted

A basic element in the extraction schema is the data field. However, akaBot Vision enables

[4] Capture Custom Table Data

Customizing Data Extract

Capturing Custom Table Data in akaBot Vision

field** == If you are missing some fields when capturing data from the document, navigate to the Fields to Capture tab in the queue settings. In this tab, you can manage pre-trained data fields and select which

="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot

supports only strings and String variables. E.g: “WordIWantToSearch” Data Table (DataTable

for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn

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

Look Up Data Table

look up data table.jpg

Data Table

Look Up Data Table

in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail"]]>>attach:look up data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Lookup Value

only strings and String variables. E.g: “WordIWantToSearch” * **Data Table (DataTable

RCA.Activities.Core.JoinDataTables Description This activity allows you to add different data from different tables using common values with each other. (* is mandatory) In the body of activity Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable

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

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 (DataTable)*** - The DataColumn object whose value is to be retrieved from the DataRow. **Misc** * **Public

this variable” + intName.toString. Properties Misc 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. Display Name (String

(TextWriter) - This box is optional. Sends the content in the Text property to a different target from

)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security

the content in the Text property to a different target from the default Output pane. ))) {{velocity