Search: output-data-table

Table Output Data Table (DataTable) - The Data Table variable that contains the generated 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

Build Data Table

build data table.jpg

Data Table

Build Data Table

to organize and structure your code better. **Eg**: Build Data Table **Output** * **Data Table (DataTable

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

/FULL. Output Output Data Table (DataTable) - The output in the type of 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

Join Data Tables

join data table.jpg

Data Table

Join Data Table

Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output 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

. Output Data table (DataTable) - the filtered Data table as an output of the activity, stored

. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports

Filter Data Table

filter data table.jpg

Data Table

. **Output** * **Data table (DataTable)** - the filtered Data table as an output of the activity, stored

.png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data

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

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

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

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

: 30000 Output Result (Data Table) - The outputted data with type = ‘DataTable’.

) - The outputted data with type 'DataTable'. Misc Display Name (String) - The name of this activity. You can edit

RCA.Activities.Common.ExtractStructuredData Description The Extract Structured Data allows you

Extract Structured Data

Extract Structured Data

** * **Result (Data Table)** - The outputted data with type = ‘DataTable’. ))) {{velocity

milliseconds. E.g: 200 **Input** * **Selector (String)** - The outputted data with type 'DataTable'. **Misc

" %) ((( RCA.Activities.Common.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from

(milliseconds). E.g: 30000 Output Result (Data Table) - The outputted data with type = ‘DataTable’. Not allow

RCA.Activities.NativeBrowser.ExtractStructuredData Description The Extract Structured Data allows you to extract structured data from a specified webpage. (*For mandatory) In the body of activity

Extract Structured Data (NB)

Extract Structured Data (NB)

(Data Table)** - The outputted data with type = ‘DataTable’. Not allow white space in output’s name

" %) ((( RCA.Activities.NativeBrowser.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from

source containing the Structure Data needed to be extracted. If the Extracting HTML field and (Native

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

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

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

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

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

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

value is: New. * **To (DateTime) **- Filters transaction by the maximum creation date. **Output** * **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