Search: insert-data-table

the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted

can edit the name of the activity to organize and structure your code better. Eg: Insert Data Table

Table - The DataTable variable that will be inserted into the Table. The DataTable columns' names

Insert Data Table

Insert Data Table

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

to organize and structure your code better. Eg: Insert Data Table **Output** * **Affected Records (Int32

Database Connect Database Disconnect Database Transaction Execute Non Query Execute Query Insert Data Table

/view/Activities/Database/Activities/Execute%20Query/]] * [[Insert Data Table>>url:https://docs.akabot.com/bin/view/Activities/Database/Activities/Insert%20Data%20Table/]]

The DataTable Activities belongs to Core Activities Pack. It contains several activities that enable the robots to manipulate data tables by adding or extracting information. See also: Release Notes Activities

Data Table

Data Table

the robots to manipulate data tables by adding or extracting information. ))) See also: * [[Release Notes>>path:/bin/view/Activities/Data%20Table/%5B1%5D%20Release%20Notes/]] * [[Activities>>path:/bin/view/Activities/Data%20Table/Activities/]] ))) )))

must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc

position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you

Excel Insert Columns Table

Excel Insert Columns Table

)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want

name (String)** - Table name you want to insert. E.g: "Table1" **Misc** * **Public (Boolean

to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity

DataTable. (* is mandatory) Properties Input Data Table(DataTable)* - The data table that you want to clear the data. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data

the name of the activity to organize and structure your code better. Eg: Clear Data Table.

Clear Data Table

clear data table.jpg

Data Table

Clear Data Table

data table.jpg]]>>attach:clear data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Table(DataTable)*** - The data table that you want to clear the data. **Misc** * **Public

to organize and structure your code better. **Eg**: Clear Data Table. ))) {{velocity}} #if ($xcontext.action

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.

Build Data Table

build data table.jpg

Data Table

Build Data Table

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

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

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

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

. 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

to insert image to. E.g: “Employee Data” Range (String)* - The range you want to add image to. E.g: “K1:L1

file you want to insert. This field accepts only strings and String variables. E.g: “C:\FolderName

path of the image or click “…” button to choose file you want to insert. This field accepts only

Excel Insert Image

Excel Insert Image

want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image

(String)** - Input the full path of the image or click “…” button to choose file you want to insert

path of the image or click “…” button to choose file you want to insert. This field accepts only