Hello...I would like to sort the output of the Attributepivoter. Is this possible? For example, one of the group by rows is month and I want to sort this output based on the calendar year months (Jan. to December). Thanks.
Solved
Sort AttributePivoter Output
Best answer by takashi
Hi @aviveiro, if you create another attribute that stores a date string (e.g. April/01/2017) containing the MONTH_NFI value, you can use the DateTimeConverter to convert it to a number 1 - 12 representing the order of the month in a year (e.g. 4). You can then sort the features with the Sorter.
DateTimeConverter Setting Example
- Input Format: %B/%d/%Y
- Output Format: %N
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 7843 replies
- Best Answer
Hi @aviveiro, if you create another attribute that stores a date string (e.g. April/01/2017) containing the MONTH_NFI value, you can use the DateTimeConverter to convert it to a number 1 - 12 representing the order of the month in a year (e.g. 4). You can then sort the features with the Sorter.
DateTimeConverter Setting Example
- Input Format: %B/%d/%Y
- Output Format: %N
Hi @aviveiro, if you create another attribute that stores a date string (e.g. April/01/2017) containing the MONTH_NFI value, you can use the DateTimeConverter to convert it to a number 1 - 12 representing the order of the month in a year (e.g. 4). You can then sort the features with the Sorter.
DateTimeConverter Setting Example
- Input Format: %B/%d/%Y
- Output Format: %N
