Search: output-data-table

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

Build Data Table

build data table.jpg

Data Table

Build Data Table

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

/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

Join Data Tables

join data table.jpg

Data Table

Join Data Table

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

. 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

Filter Data Table

filter data table.jpg

Data Table

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

: 30000 Output Result (Data Table) - The outputted data with type = ‘DataTable’.

) - The outputted data with type 'DataTable'. Misc Display Name (String) - The name of this activity. You can edit

RCA.Activities.Common.ExtractStructuredData Description The Extract Structured Data allows you

Extract Structured Data

Extract Structured Data

** * **Result (Data Table)** - The outputted data with type = ‘DataTable’. ))) {{velocity

milliseconds. E.g: 200 **Input** * **Selector (String)** - The outputted data with type 'DataTable'. **Misc

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

(milliseconds). E.g: 30000 Output Result (Data Table) - The outputted data with type = ‘DataTable’. Not allow

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

Extract Structured Data (NB)

Extract Structured Data (NB)

(Data Table)** - The outputted data with type = ‘DataTable’. Not allow white space in output’s name

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

source containing the Structure Data needed to be extracted. If the Extracting HTML field and (Native

, 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

] CV Table Extract Output Result (DataTable) - The retrieved table, stored in a DataTable variable

RCA.Activities.ComputerVision.CVTableExtract Description Extracts a table that is visible

to consider data security requirement before using this property. Display Name (String) - The name

CV Table Extract

CV Table Extract

to organize and structure your code better. E.g: [201135155] CV Table Extract **Output** * **Result

" %) ((( RCA.Activities.ComputerVision.CVTableExtract == **Description** == Extracts a table that is visible on the screen and stores

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

position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you

must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc

Excel Insert Columns Table

Excel Insert Columns Table

" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image

)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want

Automation of Fields Capture Custom Table Data Configure Automation Type for Pipeline Configure Fields for Data Extraction

[6] Customize Data Extract

Customizing Data Extract

* [[Automation of Fields>>path:/bin/view/akaBot%20Vision/Customizing%20Data%20Extract/Automation%20of%20Fields%20in%20akaBot%20Vision/]] * [[Capture Custom Table Data>>path:/bin/view/akaBot%20Vision

/Configure%20Automation%20Type%20for%20Pipeline%20/]] * [[Configure Fields for Data Extraction>>path:/bin

documents to extract data. Staff can create a new learning model by following these below steps: Step 1

choose base model, staff will have to create form fields and table from scratch Step 5: Click "Save

. With the Form Fields, staff should label both "Label" and "Value" for each field if having enough data

, send the learning models to production and use them to run on actual documents to extract data. Staff

||cursorshover="true"]] * If staff doesn't choose base model, staff will have to create form fields and table

" for each field if having enough data in documents. This helps the model will extract data more exactly