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

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

of the XWiki Syntax you can use in wiki pages (headings, images, tables). Headings XWiki offers 6 levels

1 Numbered list Item Subitem Item Subitem Mixed list Item 1 Item 2 Item 3 Item 4 Item 5 Tables You can create tables right into wiki pages: Table with headers in the top row table header table

>>XWiki.XWikiSyntax]] you can use in wiki pages (headings, images, tables). = Headings = XWiki offers 6 levels

. Item 1 11. Item 2 11*. Item 3 11*. Item 4 1. Item 5 = Tables = You can create tables right into wiki pages: == Table with headers in the top row == |= table header |= table header |= table header | cell

statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows

) 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

. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the 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. (* for Mandatory) In the body of activity URL (String) - Insert a specified URL in the container. Ex: “https

(Browser)* - Insert the specified browser in which activities could be active. URL (String)* - Provide

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

-20220506110901-1.png]] (* for Mandatory) **In the body of activity** * **URL (String)** - Insert

Browser (Browser)*** - Insert the specified browser in which activities could be active. * **URL (String

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

and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require

and data type for each column Step 6: Click "Save" button Table of Content

and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button

the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png

types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage

the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image

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

does not exist, a new document file is created. 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

. E.g: Working with Word. Option Password (String) - Insert Word file password to proceed. String

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

. **Option** * **Password (String) **- Insert Word file password to proceed. String variables and Strings