Hi,
today I get a little bit of confused by the new Sorter Mode "Natural":
Please, can somebody explain me, why the Mode Natural work like this?
Thanks!
Solved
Sorter - simple question - Mode Natural
+10- Contributor
- 72 replies
Best answer by danminneyatsaf
Thanks @Mark Stoakes for your answer. But when I have the same number like above in the screenshot, why is it not equal and the second attribute will sort the table?
It seams like 1.5.10 is != 1.5.10 in Natural Mode.
Hi @connecter, thank you for bringing this bug to our attention! I have filed an issue in our tracking system that the developers will try and fix. If you're interested, the issue tracking code is FMEENGINE-70765.
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.
@connecter Natural tries to combine the best of alpha and numeric sort. In alpha sort, if you have:
2 street name
11 street name
the alpha sort will give you:
11 street name
2 street name
but Natural will return :
2 street name
11 street name
plus a few other additions described in the user docs. under Sorting Attributes. Also wikipedia explains it.
+10- Contributor
- 72 replies
@connecter Natural tries to combine the best of alpha and numeric sort. In alpha sort, if you have:
2 street name
11 street name
the alpha sort will give you:
11 street name
2 street name
but Natural will return :
2 street name
11 street name
plus a few other additions described in the user docs. under Sorting Attributes. Also wikipedia explains it.
Thanks @Mark Stoakes for your answer. But when I have the same number like above in the screenshot, why is it not equal and the second attribute will sort the table?
It seams like 1.5.10 is != 1.5.10 in Natural Mode.
+59- Celebrity
- 3700 replies
Thanks @Mark Stoakes for your answer. But when I have the same number like above in the screenshot, why is it not equal and the second attribute will sort the table?
It seams like 1.5.10 is != 1.5.10 in Natural Mode.
That's certainly odd. Can you just doublecheck and make sure there's no trailing space in either of those values?
+10- Contributor
- 72 replies
Thanks @Mark Stoakes for your answer. But when I have the same number like above in the screenshot, why is it not equal and the second attribute will sort the table?
It seams like 1.5.10 is != 1.5.10 in Natural Mode.
@Hans van der Maarel , thanks for your reply. I make a bugreport from it. I create a new workflow for the bugreport. If someone would like to test the workflow. My result from Sorter with Natural Mode:
You can easily switch in the Transformer Sorter to Numeric an all is fine.
+13- Safer
- 485 replies
- Best Answer
Thanks @Mark Stoakes for your answer. But when I have the same number like above in the screenshot, why is it not equal and the second attribute will sort the table?
It seams like 1.5.10 is != 1.5.10 in Natural Mode.
Hi @connecter, thank you for bringing this bug to our attention! I have filed an issue in our tracking system that the developers will try and fix. If you're interested, the issue tracking code is FMEENGINE-70765.