Search: join-data-table

Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable)* - The first table that you want to use in the Join operation, is stored in a DataTable variable. This field

to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT

Join Data Tables

join data table.jpg

Join Data Table

Data Table

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

Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output Data Table

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

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

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

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

Excel Insert Columns Table

Excel Insert Columns Table

" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image

)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want

-builds hundreds of activities to perform the actions of automations on web, on desktop, working with data

: In the akaBot Studio click File menu, chose Options. Step 2: In the table Options, click References Directories

of automation projects. These activities enable robots: Manipulate the data by adding/extracting/reading

on web, on desktop, working with data base, generating the PDF files, sending emails… This document aims

Options. * Step 2: In the table Options, click References Directories tab, click Add button and chose

enable robots: * Manipulate the data by adding/extracting/reading information. * Directly interaction

Connection - Set connection string, data source, data provider. Properties Connection Configuration

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

of activity** == **Configure Connection **- Set connection string, data source, data provider. [[image:image

if you want to publicize it. Remember to consider data security requirements before using it. * **Display

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))

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

it, the data of this activity will be shown in the log. Be careful, consider data security before using

="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2

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

(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 of this activity. You can edit

}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc

property makes the XMLString property unusable. 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

it, the data of this activity will be shown in the log. Be careful, consider data security before using

="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))