Search: join-data-table

, 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

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

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

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

clear data table.jpg

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.ClearDataTable == **説明** == このアクティビティでは、指定されたデータテーブルをクリアできます。 [[[[image:clear data table.jpg]]>>attach:clear data table.jpg]] *は必須。 == **プロパティ** == **入力** * **データテーブル（DataTable）***：データをクリアするデータテーブル

Data Table

Clear Data Table

merge data table.jpg

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.MergeDataTable == **説明** == このアクティビティでは、あるDataTableと現在のDataTableをマージし、変更を保存するかどうか、および現在のDataTableに存在しないスキーマをどのように処理するのかを指定します。 [[[[image:merge data table.jpg]]>>attach:merge data table.jpg]] *は必須。 == **プロパティ

Data Table

Merge Data Table

sort data table.jpg

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.SortDataTables == **説明** == このアクティビティでは、指定された列の値に基づいて、昇順または降順でデータテーブルを並べ替えることができます。 [[[[image:sort data table.jpg||class="img-thumbnail"]]>>attach:sort data table.jpg]] *は必須。 == **プロパティ** == **入力** * **データ

Data Table

Sort Data Table

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