Search: join-data-table

. 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 the DataTable. Data row (DataRow) - The DataRow object to be added to the DataTable. If this property is set, then the ArrayRow property is ignored. Data Table (DataTable)* - The DataTable object in which you want to add

RCA.Activities.Core.AddDataRow Description This activity allows you to add a Data Row

Add Data Row

add data row.jpg

Data Table

Add Data Row

is ignored. * **Data Table (DataTable)*** - The DataTable object in which you want to add a column

" %) ((( RCA.Activities.Core.AddDataRow == **Description** == This activity allows you to add a Data Row to a specified DataTable. [[[[image:add data row.jpg]]>>attach:add data row.jpg]] (* is mandatory) == **Properties** == **Input

, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable

it, the data of this activity will be shown in the log. Be careful, consider data security before using

" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables

) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece

. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity

is ignored. Eg: “Phone Number”. Data table (DataTable)* - The DataTable object from which the column is to be removed. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security

RCA.Activities.Core.RemoveDataColumn Description This activity allows you to remove a Data

Remove Data Column

remove data column.jpg

Data Table

Remove Data Column

Number”. * **Data table (DataTable)*** - The DataTable object from which the column is to be removed

" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified DataTable. [[[[image:remove data column.jpg]]>>attach:remove data column.jpg]] (* is mandatory

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

. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string

) **- Check if you want to public it. Remember to consider data security requirement before using

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) ))) **Output** * **Sheet (List< String

Each Pipeline defines the structure of Data fields that akaBot Vision extracts. Description When editing this structure you have two options: Use pre-trained Data fields – AkaBot Vision’s Generic AI engine has been pre-trained to recognize specific Data fields and enables you to start extracting data

[3] Configure Fields for Data Extraction

Customizing Data Extract

Configuring Fields for Data Extraction

="wikigeneratedid" id="HParagraph1" %) Each Pipeline defines the structure of Data fields that akaBot Vision

options: * Use pre-trained Data fields – AkaBot Vision’s Generic AI engine has been pre-trained to recognize specific Data fields and enables you to start extracting data without any additional training

or sheet (including values, formulas, table format, and cell format) and pastes it to another location

Destination Cell (String)* - The starting cell where you want to paste the copied data. This field supports

the copied data into. This field supports only strings and String variables E.g: “TargetSheetName” Input

, table format, and cell format) and pastes it to another location in the current workbook

to SpeadSheet** * **Destination Cell (String)* **- The starting cell where you want to paste the copied data

)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g

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

, 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

RCA.Activities.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used

Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before

in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

at. **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security

="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}

further. The default amount of time is 30000 milliseconds. E.g: 30000 Output Result (Data Table

RCA.Activities.Browser.ExtractStructuredData Description The Extract Structured Data allows you to extract structured data from a specified webpage. (* For mandatory) In the body of the activity Pick

[17]Extract Structured Data

[17]Extract Structured Data

of time is 30000 milliseconds. E.g: 30000 **Output** * **Result (Data Table)* **- The outputted

" %) ((( RCA.Activities.Browser.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from

(String)** - This property allows you to input the page source contained the Structure Data needed