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!
Page 1 / 1
@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.
@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.
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?
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.
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.