Search: insert-data-table

it (*For mandatory) In the body of activity URL to be inserted (String)* - The URL that you want to open

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

]] (*For mandatory) == **In the body of activity** == * **URL to be inserted (String)*** - The URL that you want

want to public it. Remember to consider data security requirement before using it. Default is uncheck

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

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

generate data table.jpg

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.GenerateDataTable == **説明** == 構造化テキストからDataTable型変数を生成します。このアクティビティでは、生成されたテーブルに応じた列と行の区切り文字を選択できます。 [[[[image:generate data table.jpg||class="img-thumbnail"]]>>attach:generate data table.jpg]] *は必須。 == **プロパティ

Data Table

Generate Data Table

ouput data table.jpg

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activties.Core.OutputDataTable == **説明** == このアクティビティでは、CSV形式を使用してDataTableを文字列に書き込むことができます。 [[image:ouput data table.jpg]] *は必須。 == **プロパティ** == **入力** * **データテーブル（DataTable）***：出力するデータテーブル。 **その他** * **公開（チェックボックス）**：公開

Data Table

Output Data Table