Join

This operation joins the input data character string in the CSV file and outputs it to the subsequent component.

You can display the join operation screen by displaying the script canvas on the Designer screen, clicking the following items in the following order, and then dragging and dropping the component icon onto the script canvas:

  • Tool palette > Conversion > CSV > Join

Note

The CSV adapter has specific functional restrictions.

For details on functional restrictions, refer to Functional restrictions specific to CSV adapter.

 

Figure 3.2 Join operation screen

(1) Field list

This is a list of the fields to configure for the join operation.

Table 3.2 Field list

Field Name

Initial Value

Setting Value

Omission

Notes

Name

 

Single-byte alphanumeric characters and certain symbols (*1)

-

A value that begins with a single-byte alphabetic character

Input data

(No input data)

Name of the input data component

-

Select from list (*2)

Required settings

 

Column list

 

 

-

 

Details

 

Delimiter

Comma

 

✓

Select from list

Encoding used when reading column names

UTF-8

 

✓

Select from list

Stream setting

 

Relation-to-Stream Operator

RSTREAM

 

✓

Select from list

Window type

TUPLES

 

✓

Select from list

Window

1

From 1 to 999999999

✓

Set as integer

Comment

 

Comment

 

Characters

✓

 

✓

:

Possible to omit

-

:

Impossible to omit

*1

:

Only "_" (underscore) can be specified.

*2

:

When component icons for input or conversion are placed on the script canvas, the options are displayed in the list.

(2) Description of each field

This section explains each of the fields to configure for the join operation.

After changing these settings, click Finish to save the settings.

Click Cancel to discard the changes.

Name

Name of the join operation component

Single-byte alphanumeric characters and "_" (underscore) can be used.

Use a value that begins with a single-byte alphabetic character.

Input data

Selection of the component name of the input data for performing the join operation

From the input data component names displayed in the list, select the name of the component for the join operation.

Required settings

Column list

Input data column names

You can specify a file by using Read the first line of the file as column names to obtain the column names of the first line of the file.

Click Up or Down to move a column name.

Click Add or Delete to add or delete a column name.

Details

Delimiter

Output data delimiter

Select the delimiter for the output data from the following choices:

  • Comma

  • Tab

  • Space

If you omit this setting, "Comma" is selected.

Encoding used when reading column names

Encoding used when reading column names

Select from the following encodings used for the file specified using Read the first line of the file as column names:

  • UTF-8

  • SHIFT-JIS

  • Windows-31J

If you omit this setting, "UTF-8" is used to read the column names.

Stream setting

Relation-to-Stream Operator

Method for stream operation

The stream operation converts the results data of relational operations into stream data.

Data such as all data (RSTREAM) or added data (ISTREAM) is output as stream data according to changes in the output relation (*1).

Select from the following methods for stream operation:

  • RSTREAM

    All data is processed.

  • ISTREAM

    Only data that differs from the directly preceding data is processed.

If you omit this setting, "RSTREAM" is used to perform the operation for the relation.

Window type

Processing unit for stream operation

Select from the following units for processing with the stream operation:

  • TUPLES

    Use tuples (*2) for processing.

  • SECONDS

    Use seconds for processing.

  • MILLISECONDS

    Use milliseconds for processing.

If you omit this setting, "TUPLES" is selected.

Window

Execution count for stream operation

Specify a number from "1" through "2147483646" for the execution count for the stream operation.

If you omit this setting, "1" is selected.

*1

:

The operation is executed during conversion processing, and the data that will become the result is extracted as a relation.

This relation is called output relation.

*2

:

A tuple represents a stream component. A tuple is used as the unit for data that moves the stream.

Comment

Comment

Comment regarding the join operation

You can enter a comment.