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

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

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

Insert Data Table

Insert Data Table

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

(String)***- The SQL table in which the data is to be inserted. E.g: “TargetedTable” **Misc** * **Public

of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you

using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored

RCA.Activities.Word.GetTable Description This activity allows you to retrieve a table from

Get Table

Get Table

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

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

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

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

**Output** * **Result (DataTable) **- This is the data table that you have added to the queue

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

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

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

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

data according to the reference. There are two options: ・Start with: Look for items whose references

) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit

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

from a table. Output Affected Records (Int32) - The result of the execution of the SQL command

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

it. Remember to consider data security requirements before using it. * **Display Name (String)** - The name