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
- 157Activities
- 8akaBot Center
- 4akaBot Vision
- 2Data Service
- 1App Connect
- … 3 more
Last author
- 39Giang Tran
- 34Nga Nguyen
- 26VuNH54
- 23admin
- 22DatPT
- … 3 more
Creator
- 80admin
- 50Giang Tran
- 18Tuan Nguyen
- 16Nga Nguyen
- 6DatPT
- … 2 more
Last modification date
Creation date
Object type
- 2Activities
- 1Overview
Uploaded by
- 57Giang Tran
- 44Nga Nguyen
- 33Nhan Nguyen
- 21admin
- 18Tuan Nguyen
- … 3 more
Upload date
Clear Data Table
Located in
- Rendered document content
the name of the activity to organize and structure your code better. Eg: Clear Data Table.
…DataTable. (* is mandatory) Properties Input Data Table(DataTable)* - The data table that you want to clear the data. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data
- Title
Clear Data Table
- Attachment name
clear data table.jpg
- Location
Clear Data Table
…Data Table
- Raw document content
** * **Data Table(DataTable)*** - The data table that you want to clear the data. **Misc** * **Public
…to organize and structure your code better. **Eg**: Clear Data Table. ))) {{velocity}} #if ($xcontext.action
…" %) ((( RCA.Activities.Core.ClearDataTable == **Description** == This activity allows you to clear a specified DataTable. [[[[image:clear
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
Build Data Table
Located in
- Rendered document content
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
…Table Output Data Table (DataTable) - The Data Table variable that contains the generated table.
- Title
Build Data Table
- Attachment name
build data table.jpg
- Location
Data Table
…Build Data Table
- Raw document content
" %) ((( 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
…to organize and structure your code better. **Eg**: Build Data Table **Output** * **Data Table (DataTable
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
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
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
[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