Search: join-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/Get%20Row%20Item/]] * [[Join Data Tables>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Join%20Data%20Table/]] * [[Look Up Data Table

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

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

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

Data Table

Sort 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)* **- The data table variable you want to sort. This field supports only DataTable variables **Misc

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

at: [email protected] for more assistant. Step 4: Choose one or more users to join this pipeline for reviewing documents (if need). Step 5: Click "OK" button to complete creating a new pipeline. Table

:1704877579310-775.png||height="377" width="566"]] **Step 4**: Choose one or more users to join this pipeline

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) )))

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.

Data Table

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