検索:look-up-data-table
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 63Activities
- 1akaBot Studio
作成者
- 33admin
- 14Giang Tran
- 10Nga Nguyen
- 6Tuan Nguyen
- 1VuNH54
最終更新日
- 6430日以前
作成日
- 6430日以前
アップロードした人
- 31Nhan Nguyen
- 15VuNH54
- 14Giang Tran
- 10Nga Nguyen
- 6Tuan Nguyen
アップロード日
- 10030日以前
Clear Data Table (en)
保存場所
- 表示されるドキュメントの内容
DataTable. (* is mandatory) Properties Input Data Table(DataTable)* - The data table that you want to clear the data. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data
…the name of the activity to organize and structure your code better. Eg: Clear Data Table.
- タイトル
Clear Data Table
- 添付ファイルの名称
clear data table.jpg
- 保存場所
Data Table
…Clear Data Table
- ドキュメントの内容のソース
data table.jpg]]>>attach:clear data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Table(DataTable)*** - The data table that you want to clear the data. **Misc** * **Public
…to organize and structure your code better. **Eg**: Clear Data Table. ))) {{velocity}} #if ($xcontext.action
Build Data Table (en)
保存場所
- 表示されるドキュメントの内容
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
…Table Output Data Table (DataTable) - The Data Table variable that contains the generated table.
- タイトル
Build Data Table
- 添付ファイルの名称
build data table.jpg
- 保存場所
Data Table
…Build Data Table
- ドキュメントの内容のソース
" %) ((( 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
…to organize and structure your code better. **Eg**: Build Data Table **Output** * **Data Table (DataTable
Join Data Tables (en)
保存場所
- 表示されるドキュメントの内容
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
…to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT
- タイトル
Join Data Tables
- 添付ファイルの名称
join data table.jpg
- 保存場所
Data Table
…Join 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
…** * **Data Table1 (DataTable)*** - The first table that you want to use in the Join operation, is stored
Filter Data Table (en)
保存場所
- 表示されるドキュメントの内容
Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports
…. Output Data table (DataTable) - the filtered Data table as an output of the activity, stored
…to consider data security requirements before using it. Display Name (String) - The name of this activity. You
- タイトル
Filter Data Table
- 添付ファイルの名称
filter data table.jpg
- 保存場所
Data Table
- ドキュメントの内容のソース
.png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable
…. **Output** * **Data table (DataTable)** - the filtered Data table as an output of the activity, stored
…button so that you can access the wizard and customize your settings at any time. [[[[image:filter data
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
Get Queue Items (en)
保存場所
- 表示されるドキュメントの内容
date. Output Queue Items (INumerable< QueueItem >) - This is the data table that you have added
…of transactions up to 100 from an indicated queue according to multiple filters such as creation date, priority
…it. Remember to consider data security requirements before using it. Display Name (String) - The name
- ドキュメントの内容のソース
** * **Queue Items (INumerable< QueueItem >)** - This is the data table that you have added the queue
…data according to the reference. There are two options: ・Start with: Look for items whose references
…" %) ((( RCA.Activities.Core.GetQueueItems == **Description** == This activity allows you to retrieve a list of transactions up to 100 from
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
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
For Each Row (en)
保存場所
- 表示されるドキュメントの内容
loop variable name in - Data table to loop Body - Add activities that you want to execute in loop Properties Input Data Table (DataTable)* - The DataColumn object whose value is to be retrieved from the DataRow. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security
- 保存場所
Data Table
- ドキュメントの内容のソース
) == **In the body of activity** == **Foreach** - Set loop variable name **in** - Data table to loop **Body **- Add activities that you want to execute in loop == **Properties** == **Input** * **Data Table
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before