Build data table

Created by akaBot Support, Modified on Thu, 14 Nov, 2024 at 5:50 PM by akaBot Support

Introduction to the "Build Data Table" Activity

TABLE OF CONTENTS

Activity program name
Description
Properties
Usage

1. Activity program name

RCA.Activities.Core.BuildDataTable

2. Description

Up to Studio Version 2.0.2.0
Quick Access: "Toolbox" > "Data Table" > "Build Data Table"

From Studio Version 2.0.3.0
Quick Access: "Toolbox" > "Core" > "Data Table" > "Build Data Table"

This activity creates a new data table. It is suitable in cases where there is no source to load from, an empty data table needs to be created, or a fixed content data table needs to be generated.

Note: Operation confirmed with Studio version 2.2.0.4. Some wording may vary depending on the version.

3. Properties

Property Item	Property Name	Input Field	Description
Other	Public	Checkbox	Variables and arguments in the activity are logged in the log file and pushed to Center. (Refer to "About the 'Public' Property Item" for details)
Other	Display Name	Any String	Reflected in the activity name in the designer panel.
Output	Data Table	Input (DataTable Type)	The created data table is stored here.

4. Usage

Drag and drop the "Data Table > Build Data Table" activity from the Toolbox onto the Designer panel.

Click “Variables” tab to create Variable. The name is rateTable and the type is DataTable

Click “Output, A pop-up will appear with "Name:". Enter the variable name and press Enter to set it in the Properties. In this example, we will create an "exchange rate table" with the variable named "rateTable."

Click on the "Data Table…" button on the Designer panel.

The "Build Data Table" window will pop up.

Click the "+" button on the header row to add columns, or the "×" button to delete them. You can also edit column information using the pencil icon.

The "×" button on the data row allows you to delete rows.

Although you can edit using the pencil icon, in this example, we will recreate it from scratch.

First, delete the initially set columns.

Proceed to create the data table by adding columns.

The following window will be displayed.

Each item is described below:

Item	Description
Column Name	Enter the name of the column.
Data Type	Select the type of data.
Allow Null	Check this box to allow null values (unset values).
Auto Increment	Check this box to set the column as auto-numbered. The value will automatically increment by one each time a row is added. This option is available when the data type is set to Int32.
Default Value	Set the default value.
Unique	Check this box to disallow duplicate values in the column. Rows with duplicate data will be rejected.
Max Length	Specify the maximum number of characters. -1 indicates no limit. Applicable when the data type is a string.

Specify the column name and data type, then click the "OK" button.

The "Currency (Currency Unit)" column has been added.

Following the same steps, create a column named "Exchange Rate (JPY)" with data type "System.Double."

Enter data into the data table by editing each cell. Press the Tab key to confirm a cell entry and the Enter key to confirm a row entry. After pressing Enter, you will move to a new row. Once finished, click the "OK" button.

The data table has been successfully created, and the result is reflected in the "rateTable" variable.

To verify the output of the data table, use "Output Data Table" to convert it to a string and display it in the output panel using "Write Line," or display it in a message box with "For Each Row."

Note: Starting from Studio version 2.0.1.7, a pencil icon was added to allow editing of column information. Although some screenshots do not include this icon, the operations are the same.