検索:merge-data-table
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 389Activities
- 17akaBot Vision
- 12akaBot Center
- 4akaBot Insights
- 3Data Service
- … あと4件
最終更新者
- 93Nga Nguyen
- 70Tuan Nguyen
- 63VuNH54
- 61admin
- 59Nhan Nguyen
- … あと3件
作成者
- 254admin
- 68Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 10Nhan Nguyen
- … あと2件
最終更新日
- 10230日以前
作成日
- 27630日以前
オブジェクトの種類
- 5Activities
- 3aka Bot Center
- 2Live Table
- 2UI Extension
- 1Overview
- … あと1件
ファイルの種類
アップロードした人
- 141Nga Nguyen
- 101Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 46admin
- … あと3件
アップロード日
- 10430日以前
Insert Data Table (en)
保存場所
- 表示されるドキュメントの内容
and descriptions must match the ones from the database table. Table Name - The SQL table in which the data
…to access the database. E.g: “System.Data.SqlClient” Input Data Table (DataTable)* - The DataTable
…the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted
- タイトル
Insert Data Table
- 保存場所
Insert Data Table
- ドキュメントの内容のソース
and descriptions must match the ones from the database table. * **Table Name **- The SQL table in which the data
…” **Input** * **Data Table (DataTable)*** - The DataTable variable that will be inserted into the Table
…(String)***- The SQL table in which the data is to be inserted. E.g: “TargetedTable” **Misc** * **Public
Look Up Data Table (en)
保存場所
- 表示されるドキュメントの内容
supports only strings and String variables. E.g: “WordIWantToSearch” Data Table (DataTable
…to organize and structure your code better. Eg: Look up the data table Output Cell Value - Optional
…for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn
- タイトル
Look Up Data Table
- 添付ファイルの名称
look up data table.jpg
- 保存場所
Data Table
…Look Up Data Table
- ドキュメントの内容のソース
only strings and String variables. E.g: “WordIWantToSearch” * **Data Table (DataTable
…the data table **Output** * **Cell Value** - Optional. The value found in the cell that has the Row
…in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail
[4] Capture Custom Table Data (en)
保存場所
- 表示されるドキュメントの内容
. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table
…A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. Adding a predefined table field If you are missing
- タイトル
[4] Capture Custom Table Data
- 保存場所
Capturing Custom Table Data in akaBot Vision
…Customizing Data Extract
- ドキュメントの内容のソース
, click [Add Field], select Data Type = “table” and then input the value you want to create a new table
…="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. == **Adding a predefined table
Remove Duplicated Rows (en)
保存場所
- 表示されるドキュメントの内容
duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember
…Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.
- 保存場所
Data Table
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table
…** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public
…** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity
[2] Add New Field for Model (en)
保存場所
- 表示されるドキュメントの内容
and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require
…and data type for each column Step 6: Click "Save" button Table of Content
…and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button
- ドキュメントの内容のソース
the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png
…types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage
…the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image
Get Table (en)
保存場所
- 表示されるドキュメントの内容
of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you
…using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored
…RCA.Activities.Word.GetTable Description This activity allows you to retrieve a table from
- タイトル
Get Table
- 保存場所
Get Table
- ドキュメントの内容のソース
the data table * **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. **Output** * **Data Table (DataTable
…== **Description** == This activity allows you to retrieve a table from a Word Document and return
Excel Append Range (en)
保存場所
- 表示されるドキュメントの内容
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body
…, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table
…." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable
…: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables
…: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable
[4] Business (en)
保存場所
- 表示されるドキュメントの内容
based upon the value entered in the ROI data set table, as well as the days until your defined goal
…the Manual Time value entered in the ROI data set table. Goal Input Static display of your defined
…to date, based upon the Manual Time value entered in the ROI data set table. Displays the Top 10
- ドキュメントの内容のソース
value entered in the **ROI data set table**. ))) |((( **Goal ** )))|((( Input )))|((( Static display
…in the **ROI data set table**. ))) |((( **Cumulative Time Saved** )))|((( Column Chart )))|((( Total time saved
…** )))|((( Input )))|((( Displays the current total of money saved based upon the value entered in the **ROI data
Excel Insert Columns Table (en)
保存場所
- 表示されるドキュメントの内容
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
Append CSV File (en)
保存場所
- 表示されるドキュメントの内容
of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable
- ドキュメントの内容のソース
of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append
…\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV
…)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security