Bug Report: Editable dataset always sorting as text
I think Ive found a bug on how the editable dataset sorts integer columns:
Im trying to sort descending and its doing alphabetically, which is not desired.
Operating system used: MacOS and Windows
Answers
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
Hi,
If you go to the explore view after saving the dataset, what meaning does the data have? In my case I have 'integer', and the data gets sorted as expected:
In the case where the meaning is 'text' I get the behaviour you mention.
If you are doing the sorting on the Edit tab, this is expected as the schema has not been applied to the data yet and everything is a string.
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,160 Neuron
I agree with Miguel, this works fine if you Explore the dataset. In the Edit tab it's all a piece of text so it's final if sorted alphabetically.
-
In my opinion, is inconvenient and slightly confusing since the Edit tab already displays "int" type so I am expecting to be able to sort integers.
But I understand what you say, feel free to close the bug or should I?
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,160 Neuron
I don't think this is a bug since it's behaving as designed. You may argue that it's inconvenient and slightly confusing but given the solution is to use the Explore tab it might be one of those where it's best to move on as there is an easy workaround.