Search: join-data-table

Custom Table Data</a> </div> </div> </div> <div class="akb-card"> <div class="akb

</a> <a href="/bin/view/akaBot%20Vision/Quick%20start%20guide/Validate%20the%20Data/">Validate the Data

-card-title">Customize Data Extract</div> <div class="akb-card-body"> <div class="akb-link

After importing the document successfully and the data extraction process is successfully finished

, akaBot Vision provides users with the capability to add or remove rows in a table To insert a row, you can click "+" icon To delete a row, you can click "x" icon To add a new row at the end of the table

="wikigeneratedid" %) After importing the document successfully and the data extraction process is successfully

with this status in the “To review” tab in the user interface. [[image:image-20220420193327-1.png||data-xwiki

in each field that has been detected incorrectly [[image:image-20220420193327-2.png||data-xwiki-image

the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable

\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log

** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t

)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole

range in a data table variable. Only data table variables are supported ))) {{velocity

: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g

want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole

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

Add Data Column

add data column.jpg

Data Table

Add Data Column

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

RCA.Activities.Core.RemoveDataRow Description This activity allows you to remove a Data Row to a specified DataTable. (* is mandatory) Properties Input Data Row (DataRow)* - The DataRow object which is to be removed. Data Table (DataTable)* - The DataTable object from which the row is removed. Row Index (Int

Remove Data Row

remove data row.jpg

Data Table

Remove Data Row

" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified DataTable. [[image:remove data row.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable

. Only string variables and strings are supported. Data Table - The data that you want to write

to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data

RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from

and strings are supported. * **Data Table** - The data that you want to write to the specified range

which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable

" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable

are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable

in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you

". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data

and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added

to public it. Remember to consider data security requirement before using it. * **Display Name (String

. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data

RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from

and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified

** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable

" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable

in edit mode. Select Data Source. Search jhi_dataset table and drag it to the data source interface. Select a relationship with an existing table on the data source interface.

Dataset The default columns in the Business Dataset table are Manual Time and Hourly Cost. You can also

[1] ROI data set

in edit mode. 1. Select **Data Source**. 1. Search **jhi_dataset **table and drag it to the data source interface. 1. Select a relationship with an existing table on the data source interface. ))) {{velocity

** == The default columns in the **Business Dataset** table are **Manual Time** and **Hourly Cost**. You can also