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
Location
- 281Activities
- 14akaBot Vision
- 12akaBot Center
- 3akaBot Insights
- 2Data Service
- … 5 more
Last author
- 87Nga Nguyen
- 55Tuan Nguyen
- 50admin
- 47VuNH54
- 37Nhan Nguyen
- … 3 more
Creator
- 206admin
- 38Tuan Nguyen
- 35Nga Nguyen
- 24Giang Tran
- 8DatPT
- … 2 more
Last modification date
Creation date
Object type
- 2Activities
- 1Overview
- 1Rights
- 1aka Bot Center
- 1aka Bot Vision
Uploaded by
- 141Nga Nguyen
- 67Nhan Nguyen
- 51admin
- 39Tuan Nguyen
- 24Giang Tran
- … 3 more
Upload date
Build Data Table
Located in
- Rendered document content
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
- Title
Build Data Table
- Attachment name
build data table.jpg
- Location
Data Table
…Build Data Table
- Raw document content
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
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
Extract Structured Data
Located in
- Rendered document content
: 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
- Title
Extract Structured Data
- Location
Extract Structured Data
- Raw document content
** * **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
Extract Structured Data (NB)
Located in
- Rendered document content
(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
- Title
Extract Structured Data (NB)
- Location
Extract Structured Data (NB)
- Raw document content
(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
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