[Document Mapper]Sort by Two Keys

Logic Name

Sort by Two Keys

Function

Sorts by two conditions.

Data Types

Location	Type
The first input handler	Loop
The second input handler	String
The third input handler	String
Logic output	Loop

Refer to "Logic Specifications" for details.

Properties

Category	Property	Description
Required	Sort order	Specify the sort order.
Required	Order	Specify the order.
Required	Sort order	Specify the sort order.
Required	Order	Specify the order.
Comment	Comment	The comment will also be output to the specifications.It does not affect the conversion process.

Function Details

Sort order

Refer to "Property Setting Method" of "Sort by Key".

Criteria for Sort order

The first sorting condition is the upper property, and the second is the below property.
The second sorting condition is applied when it is equal to the key data for the first sorting condition and decide the order between the two.

Specification Limits

You are not allowed to make a mapping of the input data specified as a key to an input handler of the following collective logic (sum value, average value, # of node, the max value of node, and the minimum value of node).

You cannot assign data including null to a key.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The logic sorts input data by the value of column "prefecture code" and "city code" as the first and second key, in lowercase-first ascending order, and outputs data.

Property Settings

Property	Setting
Sort order	Lowercase-first string order
Order	Ascending
Sort order	Lowercase-first string order
Order	Ascending

Input Data

001,Tokyo,108,Chiyoda ku

003,Chiba,301,Chiba city

001,Tokyo,101,Bunkyo ku

002,Osaka,201,Osaka city

001,Tokyo,128,Musashino city

Output Data

001,Tokyo,101,Bunkyo ku

001,Tokyo,108,Chiyoda ku

001,Tokyo,128,Musashino city

002,Osaka,201,Osaka city

003,Chiba,301,Chiba city