Search: clear-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
- 239Activities
- 16akaBot Vision
- 8akaBot Center
- 3Data Service
- 3akaBot Insights
- … 4 more
Last author
- 60Tuan Nguyen
- 55Nga Nguyen
- 47VuNH54
- 46admin
- 39Nhan Nguyen
- … 3 more
Creator
- 177admin
- 42Tuan Nguyen
- 26Nga Nguyen
- 19Giang Tran
- 9Nhan Nguyen
- … 1 more
Last modification date
Creation date
Object type
- 2Activities
- 1Overview
- 1aka Bot Vision
Uploaded by
- 105Nga Nguyen
- 74Nhan Nguyen
- 47admin
- 43Tuan Nguyen
- 21Giang Tran
- … 3 more
Upload date
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
Join Data Tables
Located in
- Rendered document content
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
- Title
Join Data Tables
- Attachment name
join data table.jpg
- Location
Data Table
…Join Data Table
- Raw document content
" %) ((( 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
Filter Data Table
Located in
- Rendered document content
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
- Title
Filter Data Table
- Attachment name
filter data table.jpg
- Location
Data Table
- Raw document content
.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
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
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
[4] Capture Custom Table Data
Located in
- Rendered document content
. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table
…A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. Adding a predefined table field If you are missing
- Title
[4] Capture Custom Table Data
- Location
Capturing Custom Table Data in akaBot Vision
…Customizing Data Extract
- Raw document content
, click [Add Field], select Data Type = “table” and then input the value you want to create a new table
…="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. == **Adding a predefined table
[02]Clear Collection
Located in
- Rendered document content
you want to clear. You can select different options based on the Data type of the collection you use
…to clear a specified collection of all items (* for Mandatory) Properties Misc Collection (ICollection<T>)* - You can enter your collection you want to be cleared here. Display Name (String) - The name
- Title
[02]Clear Collection
- Location
[01]Clear Collection
- Raw document content
" %) ((( System.Activities.Statements.ClearCollection<System.Int32> == **Description** == This activity allows to clear a specified collection of all
…** * **Collection (ICollection<T>)*** - You can enter your collection you want to be cleared here. * **Display Name
…your code better. E.g: “Clear Collection” * **Public (Checkbox)** - Check if you want to public
[8] Advanced Filter in Data Service
Located in
- Rendered document content
Step 1: Navigate to the Data tab of the desired entity in Data Service. Step 2: To apply more filters on your results list, click Advanced Filter. The pop-up Advanced Filter will open Step 3: User
…a conditions, click the corresponding Delete icon or if you want to clear all filter, click Clear all
- Title
[8] Advanced Filter in Data Service
- Location
Data Service
…[2] How to use Data Service
…[8] Advanced Filter in Data Service
- Raw document content
(% class="box infomessage" %) ((( **Step 1: ** Navigate to the **Data** tab of the desired entity in Data Service. ))) [[image:image-20230630132517-1.png]] (% class="box infomessage" %) ((( **Step 2
…to clear all filter, click **Clear all conditions** button ))) 1. Click **Filter** to rerun the search
[1] Design Form
Located in
- Rendered document content
Table Tabs Well Data Include components used to collect data Hidden Container Data map Data grid Edit
…the ability to collect user data UI components are divided into 5 main groups, based on their functions
…to fill in. Then click Save when you are done. The below table describes frequently used configure
- Raw document content
|((( * HTML element * Content * Columns * Field set * Panel * Table * Tabs * Well ))) |Data|Include components used to collect data|((( * Hidden * Container * Data map * Data grid * Edit grid * Tree ))) |Premium
…provide users the ability to collect user data [[image:1695034818758-663.png||height="379" width="1014
CV Check
Located in
- Rendered document content
RCA.Activities.ComputerVision.CVCheck Description Selects, clears, or toggles check boxes
…. ・Uncheck - Clear a check box. ・Toggle - Switches the value of a check box. Descriptor (String
…. Remember to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
" %) ((( RCA.Activities.ComputerVision.CVCheck == **Description** == Selects, clears, or toggles check boxes. This activity can only interact
…box. **・Uncheck** - Clear a check box. **・Toggle **- Switches the value of a check box. * **Descriptor
…(Boolean) **- Check if you want to public the activity. Remember to consider data security requirement
[2] Add New Field for Model
Located in
- Rendered document content
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
- Raw document content
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