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
- 390Activities
- 17akaBot Vision
- 12akaBot Center
- 4Data Service
- 4akaBot Insights
- … 4 more
Last author
- 93Nga Nguyen
- 70Tuan Nguyen
- 65VuNH54
- 60admin
- 59Nhan Nguyen
- … 3 more
Creator
- 254admin
- 67Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 10Nhan Nguyen
- … 3 more
Last modification date
Creation date
Object type
Uploaded by
- 141Nga Nguyen
- 101Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 47admin
- … 3 more
Upload date
Excel Read Column
Located in
- Rendered document content
RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined
…- The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
…)* - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
- Raw document content
RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has
…to start extracting the column data. By default, this is filled in with "A1". E.g**:** "A1
…" * **Starting Cell (String)*** - The cell from which to start extracting the column data. By default
Remove Duplicated Rows
Located in
- Rendered document content
duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember
…Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.
- Location
Data Table
- Raw document content
" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table
…** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public
…** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity
[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
Excel Read Row
Located in
- Rendered document content
. E.g: "Sheet1" Starting Cell - The cell from which to start extracting the row data. By default
…: "Sheet1" Starting Cell (String)* - The cell from which to start extracting the row data. By default
…to consider data security requirement before using it. Display Name (String) - The name of this activity. You
- Raw document content
from which to start extracting the row data. By default, this is filled in with "A1". E.g: "A1
…" * **Starting Cell (String)*** - The cell from which to start extracting the row data. By default
…to consider data security requirement before using it. * Display Name (String) - The name of this activity
Get Table
Located in
- Rendered document content
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
- 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
Get Exchange Email Messages
Located in
- Rendered document content
if you want to public it. Remember to consider data security requirement before using it. Display Name
…the attachments in the email message. By default, this check box is cleared. Is Body Html(Checkbox) - Specifies
…to mark retrieved messages as read. By default, this check box is cleared. Only Unread Messages (Checkbox
- Raw document content
)** - Check if you want to public it. Remember to consider data security requirement before using
…whether to retrieve the attachments in the email message. By default, this check box is cleared
…is cleared. * **Only Unread Messages (Checkbox) **- Specifies whether to retrieve only unread messages
Read Column
Located in
- Rendered document content
(String)* - The cell from which to start extracting the column data. By default, this is filled
…" Starting Cell (String)* - The cell from which to start extracting the column data. By default
…. Remember to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input
…)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
…to consider data security requirement before using this property. * **Display Name (String) **- The name
Read Row
Located in
- Rendered document content
(String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1
…" Starting Cell (String)* - The cell from which to start extracting the row data. By default, this is filled
…to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
extracting the row data. By default, this is filled in with "A1". E.g: "A1" == **Properties
…(String)*** - The cell from which to start extracting the row data. By default, this is filled in with "A1
…. Remember to consider data security requirement before using this property. * **Display Name (String
Excel Append Range
Located in
- Rendered document content
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body
…, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table
…." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable
…: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables
…: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable
Excel Read Cell
Located in
- Rendered document content
Contact” Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security
…is cleared. Output Result (OutArgument) - Stores the information from the specified spreadsheet cell
- Raw document content
(Checkbox)** - Check if you want to public it. Remember to consider data security requirement before using
…this check box keeps the formatting of the cell that you want to read. By default, the check box is cleared
…="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}