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
- 129Activities
Creator
- 96admin
- 32Tuan Nguyen
- 1Nhan Nguyen
Last modification date
Creation date
Object type
Uploaded by
- 58Nhan Nguyen
- 38Nga Nguyen
- 32Tuan Nguyen
- 8admin
Upload date
Merge Data Table
Located in
- Rendered document content
. (* is mandatory) Properties Input Destination (DataTable)* - The data table that takes the data from the source data table and handles the changes and missing schema. Source (DataTable)*- The data table to be merged with the destination data table. Misc Public (Checkbox) - Check if you want to publicize
- Title
Merge Data Table
- Attachment name
merge data table.jpg
- Location
Data Table
…Merge Data Table
- Raw document content
** == **Input** * **Destination (DataTable)*** - The data table that takes the data from the source data table and handles the changes and missing schema. * **Source (DataTable)***- The data table to be merged with the destination data table. **Misc** * **Public (Checkbox)** - Check if you want
Output Data Table
Located in
- Rendered document content
RCA.Activties.Core.OutputDataTable Description This activity allows you to write a Data Table to a string using the CSV format. (* is mandatory) Properties Input Data Table (DataTable)* - The data
…can edit the name of the activity to organize and structure your code better. Eg: Output data table
- Title
Output Data Table
- Attachment name
ouput data table.jpg
- Location
Data Table
…Output Data Table
- Raw document content
" %) ((( RCA.Activties.Core.OutputDataTable == **Description** == This activity allows you to write a Data Table to a string using
…** * **Data Table (DataTable)*** - The data table that you want to output. **Misc** * **Public (Checkbox
…and structure your code better. **Eg**: Output data table **Output** * **Text **- The output of the Data
Sort Data Table
Located in
- Rendered document content
RCA.Activities.Core.SortDataTables Description This activity allows you to sort data tables
…Input Data Table (DataTable)* - The data table variable you want to sort. This field supports only
…the name of the activity to organize and structure your code better. Eg: Sort Data table Output Output
- Title
Sort Data Table
- Attachment name
sort data table.jpg
- Location
Data Table
…Sort Data Table
- Raw document content
" %) ((( RCA.Activities.Core.SortDataTables == **Description** == This activity allows you to sort data tables in ascending or descending
…"]]>>attach:sort data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Table (DataTable)* **- The data table variable you want to sort. This field supports only DataTable variables **Misc
Generate Data Table
Located in
- Rendered document content
unstructured data to convert into a table. Only String are supported. Eg: “John | Frank | Levi” Positions
…to organize and structure your code better. Eg: Generate Data Table Output Output Data Table (DataTable) - The Data Table variable that contains the generated table. Table Options Auto Detect Types (Checkbox
- Title
Generate Data Table
- Attachment name
generate data table.jpg
- Location
Data Table
…Generate Data Table
- Raw document content
(String)*** - The field that you add unstructured data to convert into a table. Only String are supported
…Data Table **Output** * **Output Data Table (DataTable)** - The Data Table variable that contains
…. This activity enables you to select column and row separators according to which the table is generated
Look Up Data Table
Located in
- Rendered document content
supports only strings and String variables. E.g: “WordIWantToSearch” Data Table (DataTable
…to organize and structure your code better. Eg: Look up the data table Output Cell Value - Optional
…for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn
- Title
Look Up Data Table
- Attachment name
look up data table.jpg
- Location
Data Table
…Look Up Data Table
- Raw document content
only strings and String variables. E.g: “WordIWantToSearch” * **Data Table (DataTable
…the data table **Output** * **Cell Value** - Optional. The value found in the cell that has the Row
…in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail
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
[03]Get Outlook Mail Message
Located in
- Rendered document content
to public it. Remember to consider data security requirement before using it. Display Name (String
…(CheckBox) - Specifies whether to mark retrieved messages as read. By default, this check box is cleared
- Raw document content
data security requirement before using it. * **Display Name (String)** - The name of this activity
…is cleared. * **Only Unread Messages (CheckBox)** - Specifies whether to retrieve only unread messages
…') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start
[18]Check/Uncheck
Located in
- Rendered document content
to public it. Remember to consider data security requirement before using it. Default is unchecked. Options
…・Uncheck to clear a check box
- Raw document content
)** - Check if you want to public it. Remember to consider data security requirement before using it. Default
…a check box or radio button ・Uncheck to clear a check box ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc
[11]Type Into
Located in
- Rendered document content
(Checkbox) - A checkbox specifies whether target field would be cleared before typing. ・Check – Empty
…if you want to public it. Remember to consider data security requirement before using it. Default
- Raw document content
be cleared before typing. **・Check** – Empty the field. **・Uncheck** – Not empty the field. **Common
…it. Remember to consider data security requirement before using it. Default is unchecked. ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content
Add Data Column
Located in
- Rendered document content
want to add to the specified DataTable Object. String supported only. Data Table (DataTable
…Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements
…to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type
- Title
Add Data Column
- Attachment name
add data column.jpg
- Location
Data Table
…Add Data Column
- Raw document content
to the specified DataTable Object. String supported only. * **Data Table (DataTable)*** - The DataTable object
…DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before