Search: join-data-table

Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable)* - The first table that you want to use in the Join operation, is stored in a DataTable variable. This field

to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT

Join Data Tables

join data table.jpg

Join Data Table

Data Table

"]]>>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

Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output Data Table

join data table.jpg

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.JoinDataTables == **説明** == このアクティビティでは、相互に共通の値を使用して、他のテーブルから他のデータを追加します。 [[[[image:join data table.jpg||class="img-thumbnail"]]>>attach:join data table.jpg]] *は必須。 == **アクティビティの内容** == **テーブル結合ウィザード：**結合条件

Join Data Table

Data Table

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

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

build data table.jpg

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.BuildDataTable == **説明** == このアクティビティでは、さまざまな設定で新しいデータテーブルを作成できます。 [[[[image:build data table.jpg||class="img-thumbnail"]]>>attach:build data table.jpg]] == **アクティビティの内容** == **データテーブル**：クリックして列を追加/削除し、列名/列タイプを更新

Data Table

Build Data Table

filter data table.jpg

できます。 [[[[image:filter data table.jpg||class="img-thumbnail"]]>>attach:filter data table.jpg]] *は必須

Data Table

Connection - Set connection string, data source, data provider. Properties Connection Configuration

) - Check if you want to publicize it. Remember to consider data security requirements before using

of activity** == **Configure Connection **- Set connection string, data source, data provider. [[image:image

if you want to publicize it. Remember to consider data security requirements before using it. * **Display

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))

to add to Content Control 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) - The name

it, the data of this activity will be shown in the log. Be careful, consider data security before using

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

to consider data security requirement before using this property. Display Name (String) - The name

)** - Check if you want to public the activity. Remember to consider data security requirement before using

!= 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4

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

. **Misc** * **Public (Checkbox)** - Check if you want to public the activity. Remember to consider data

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