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
- 124Activities
- 5akaBot Vision
Last author
- 41Giang Tran
- 24Nhan Nguyen
- 22VuNH54
- 16DatPT
- 15Tuan Nguyen
- … 1 more
Creator
- 55Giang Tran
- 44admin
- 23Tuan Nguyen
- 7Nhan Nguyen
Last modification date
Creation date
Object type
Uploaded by
- 64Giang Tran
- 42Nhan Nguyen
- 23Tuan Nguyen
- 11admin
- 3VuNH54
- … 1 more
Upload date
Output Data Table
Located in
- Rendered document content
can edit the name of the activity to organize and structure your code better. Eg: Output data table
…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
- Title
Output Data Table
- Attachment name
ouput data table.jpg
- Location
Output Data Table
…Data Table
- Raw document content
** * **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
…" %) ((( RCA.Activties.Core.OutputDataTable == **Description** == This activity allows you to write a Data Table to a string using
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
Sort Data Table
Located in
- Rendered document content
the name of the activity to organize and structure your code better. Eg: Sort Data table Output Output
…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
- Title
Sort Data Table
- Attachment name
sort data table.jpg
- Location
Data Table
…Sort Data Table
- Raw document content
of the activity to organize and structure your code better. Eg: Sort Data table **Output** * **Output Data Table
…" %) ((( 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
Remove Duplicated Rows
Located in
- Rendered document content
Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.
…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
- Location
Data Table
- Raw document content
** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity
…" %) ((( 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
Generate Data Table
Located in
- Rendered document content
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
…unstructured data to convert into a table. Only String are supported. Eg: “John | Frank | Levi” Positions
- Title
Generate Data Table
- Attachment name
generate data table.jpg
- Location
Data Table
…Generate Data Table
- Raw document content
Data Table **Output** * **Output Data Table (DataTable)** - The Data Table variable that contains
…(String)*** - The field that you add unstructured data to convert into a table. Only String are supported
…. This activity enables you to select column and row separators according to which the table is generated
Read CSV File
Located in
- Rendered document content
Data Table (DataTable) - Represents the output DataTable that contains the information obtained from
…of the CSV file E.g: “C:\CSVFolder\clientList.csv” Misc 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. Display Name (String
- Raw document content
, it is selected. **Output** * **Data Table (DataTable)** - Represents the output DataTable that contains
…” **Misc** * **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. * **Display Name (String) **- The name of this activity
[17]Extract Structured Data
Located in
- Rendered document content
further. The default amount of time is 30000 milliseconds. E.g: 30000 Output Result (Data Table)* - The outputted data with type = ‘DataTable’. Not allow white space in output’s name.
…RCA.Activities.Browser.ExtractStructuredData Description The Extract Structured Data allows you
- Title
[17]Extract Structured Data
- Location
[17]Extract Structured Data
- Raw document content
of time is 30000 milliseconds. E.g: 30000 **Output** * **Result (Data Table)* **- The outputted data with type = ‘DataTable’. Not allow white space in output’s name. ))) {{velocity
…" %) ((( RCA.Activities.Browser.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from
Look Up Data Table
Located in
- Rendered document content
to organize and structure your code better. Eg: Look up the data table Output Cell Value - Optional
…supports only strings and String variables. E.g: “WordIWantToSearch” Data Table (DataTable
…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
the data table **Output** * **Cell Value** - Optional. The value found in the cell that has the Row
…only strings and String variables. E.g: “WordIWantToSearch” * **Data Table (DataTable
…in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail