Search: sort-data-table

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

Sort Data Table

sort data table.jpg

Sort Data Table

Data Table

" %) ((( RCA.Activities.Core.SortDataTables == **Description** == This activity allows you to sort data tables in ascending or descending

)* **- The data table variable you want to sort. This field supports only DataTable variables **Misc

of the activity to organize and structure your code better. Eg: Sort Data table **Output** * **Output Data Table

Add Data Column Add Data Row Build Data Table Clear Data Table Filter Data Table For Each Row Generate Data Table Get Row Item Join Data Tables Look Up Data Table Merge Data Table Output Data Table Remove Data Column Remove Data Row Remove Duplicated Rows Sort Data Table

Data Table

://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Remove%20Duplicated%20Rows/]] * [[Sort Data Table

/Activities/Add%20Data%20Row/]] * [[Build Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Build%20Data%20Table/]] * [[Clear Data Table>>url:https://docs.akabot.com/bin/view

The DataTable Activities belongs to Core Activities Pack. It contains several activities that enable the robots to manipulate data tables by adding or extracting information. See also: Release Notes Activities

Data Table

Data Table

the robots to manipulate data tables by adding or extracting information. ))) See also: * [[Release Notes>>path:/bin/view/Activities/Data%20Table/%5B1%5D%20Release%20Notes/]] * [[Activities>>path:/bin/view/Activities/Data%20Table/Activities/]] ))) )))

. (* 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

Merge Data Table

merge data table.jpg

Data Table

Merge Data Table

** == **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

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

Output Data Table

ouput data table.jpg

Data Table

Output Data Table

" %) ((( 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

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

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

(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

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

Look Up Data Table

look up data table.jpg

Data Table

Look Up Data Table

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

. 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

[4] Capture Custom Table Data

Capturing Custom Table Data in akaBot Vision

Customizing Data Extract

, 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

a list of records for the selected Entity from the Data Service, according to specified filters

supports entities imported from Data Service. Click to add filter, the Query Builder window opens Choose

entities imported from Data Service Input Record: the ID of the record you want to retrieve from the entity

Data Service Activities

Data Service Studio Activities

Entity from the Data Service, according to specified filters. == **In the body of activity

imported from Data Service. * Click to add filter, the Query Builder window opens ** Choose the condition

with the activity. The property only supports entities imported from Data Service * Input Record: the ID

number of the requested page size Integer False Size of a page(top) sort String False Sorting criteria

of the requested page size Integer False Size of a page(top) sort String False Sorting criteria in the format

form-data File multipart/form-data environmentIds form-data Array[long] application/json Response

|Size of a page(top) |sort|String|False|((( Sorting criteria in the format: property(,asc|desc) Ex

|size|Integer|False|Size of a page(top) |sort|String|False|((( Sorting criteria in the format: property

|Parameter Type|Type|Content Type |package|form-data|File|multipart/form-data |environmentIds|form-data|Array