Search: generate-data-table

location for idea generation, implementation, and governance, akaBot Hub streamlines the automation process

codes,… for automation projects Easily keep track cost and benefits of all automation projects Table

integration process**. By providing a centralized location for idea generation, implementation, and governance

" %) ((( (% class="akb-toc-title" %) ((( Table Of Content ))) {{toc depth="4" start="2"/}} ))) )))

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

) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security

to organize and structure your code better. E.g: Invoke Method Generic Type Argument (Type) - When we want to invoke a generic method, we specify generic types in this collection. You can click

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

. E.g: Invoke Method * **Generic Type Argument (Type) **- When we want to invoke a generic method, we

, 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

:\FolderName\ClientList.xlsx” Sheet name - The sheet you want to write the data to. E.g: “ClientNames” Cell

, generic variables and strings are supported. E.g: “Hello world” or “=A2&A3” Cell - The cell that you want

want to write the data to. E.g: “ClientNames” Value (String) - The value or formula that you want

to write the data to. E.g: “ClientNames” * **Cell content **- The value or formula that you want to be written to a cell or range. Only string variables, generic variables and strings are supported. E.g

to write the data to. E.g: “ClientNames” * **Value (String) **- The value or formula that you want

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

multiple types of data, such as invoice information or customer details. This information can be processed in other systems - SAP or Salesforce, for instance.  The data stored in, and output from, Queue items

applications, processing of machine generated forms, or for analytics. See also: Release Notes Activities

multiple types of data, such as invoice information or customer details. This information can be processed in other systems - SAP or Salesforce, for instance.  The data stored in, and output from, Queue items

applications, processing of machine generated forms, or for analytics. ))) See also: * [[Release Notes

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

in the SQL parameter. ・TableDirect - Invokes all records from a table. Output Data Table (DataTable

Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command

to consider data security requirement before using it. Display Name (String) - The name of this activity. You

in the SQL parameter. ・TableDirect - Invokes all records from a table. **Output** * **Data Table (DataTable

connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities

to consider data security requirement before using it. * **Display Name (String)** - The name of this activity