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
+4Best answer by danminneyatsaf
connecter wrote:
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.
@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.
+4markatsafe wrote:
@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.
+50- Celebrity
connecter wrote:
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?
+4connecter wrote:
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.
+12- Safer
- Best Answer
connecter wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.