Search: output-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Last author
- 60Tuan Nguyen
- 55Nga Nguyen
- 46VuNH54
- 39Nhan Nguyen
- 18DatPT
- … 2 more
Creator
- 151admin
- 42Tuan Nguyen
- 26Nga Nguyen
- 18Giang Tran
- 1DatPT
- … 1 more
Last modification date
Creation date
Object type
Uploaded by
- 104Nga Nguyen
- 65Nhan Nguyen
- 42Tuan Nguyen
- 21admin
- 20Giang Tran
- … 2 more
Upload date
Join Data Tables
Located in
- Rendered document content
/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
- Title
Join Data Tables
- Attachment name
join data table.jpg
- Location
Data Table
…Join Data Table
- Raw document content
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
Filter Data Table
Located in
- Rendered document content
. 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
- Title
Filter Data Table
- Attachment name
filter data table.jpg
- Location
Data Table
- Raw document content
. **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
Get Table
Located in
- Rendered document content
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
- Title
Get Table
- Location
Get Table
- Raw document content
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
Execute Query
Located in
- Rendered document content
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
- Raw document content
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
Insert Data Table
Located in
- Rendered document content
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
- Title
Insert Data Table
- Location
Insert Data Table
- Raw document content
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
Bulk Add Queue Items
Located in
- Rendered document content
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
- Raw document content
**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
Get Queue Items
Located in
- Rendered document content
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
- Raw document content
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
Read Range
Located in
- Rendered document content
(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
…” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
…)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole
- Raw document content
is cleared **Output** * **DataTable (DataTable)** - Stores the data extracted from the specified Excel range in a data table variable. Only data table variables are supported ))) {{velocity
…: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g
For Each Row
Located in
- Rendered document content
loop variable name in - Data table to loop Body - Add activities that you want to execute in loop Properties Input Data Table (DataTable)* - The DataColumn object whose value is to be retrieved from the DataRow. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security
- Location
Data Table
- Raw document content
) == **In the body of activity** == **Foreach** - Set loop variable name **in** - Data table to loop **Body **- Add activities that you want to execute in loop == **Properties** == **Input** * **Data Table
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before
[05]For Each
Located in
- Rendered document content
, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable
…it, the data of this activity will be shown in the log. Be careful, consider data security before using
- Raw document content
" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables
…) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece
…. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity