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
lightbulbRefer 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

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