Sort by Key
Logic name
Sort by Key (Document Mapper)
Function
This logic sorts by the specified condition.
Data types
|
Location |
Type |
|---|---|
|
First input handler |
Loop |
|
Second input handler |
String |
|
Logic output |
Loop |
For details, refer to Logic specifications.
Properties
|
Category |
Property |
Description |
|---|---|---|
|
Required settings |
Sort order |
Specify the sort order. |
|
Required settings |
Order |
Specify the order. |
|
Comment |
Comment |
You can write a description of the logic. It doesn't affect the conversion process. |
Function details
Lowercase-first string order
-
Data is sorted in Unicode order, prioritizing lowercase characters.
-
Strings with the same first character are sorted in order by the second, third, fourth character and so on.
Uppercase-first string order
-
Data is sorted in Unicode order, prioritizing uppercase characters.
-
The order of sorting is the same with "Lowercase-first String order" except for the priority of uppercase.
Numerical order
-
Data is sorted by the numerical sequence of the numbers
-
If ascending order is selected, data is sorted so that values increase from top to bottom. For descending order, data is sorted in reverse order.
-
The mapped key must be of numeric type.
Specification limits
-
You are not allowed to map the input data specified as a key to an input handler of the subsequent collective logics (Sum, Average, Number of Node, Maximum Node, and Minimum Node).
-
You can't use data including null as a key.
Logic sample
Mapping definition
Logic settings and processing result
The logic sorts the product list by "price" in numeric ascending order.
Property settings
|
Property |
Setting |
|---|---|
|
Sort order |
Numerical Order |
|
Order |
Ascending |
Input data
|
Product A,10050 |
|
Product B,2468 |
|
Product C,3651 |
Output data
|
Product B,2468 |
|
Product C,3651 |
|
Product A,10050 |
For a list of logics, refer to Mapper Logic Guide.