Idea by bakkermans · May 02, 2016 at 02:58 PM · data inspector

Automatically detect if sorting in Data Inspector is alphabetical or numeric.

Just a small thing that's annoying me in the Data Inspector. My numeric fields are always sorted alphabetical by default when I click on the attribute name to sort (1, 10, 100, ...). Is it possible to detect if a field is completely numeric and sort it as such?

Add comment · Show 1

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

eswa · Aug 15, 2018 at 02:31 PM 0

This would be great, and/or as an addition: make the first click on the column numeric ascending in stead of alphabetic dec. Maybe to keep all options open: or cycle through the whole sorting option list (now it seems to stick to alphabetical, eventhough you chose numeric)

htl commented · Feb 18 at 07:10 PM

If anyone else is having this problem, please take the time to comment here. The more people report this error, the likelier that Safe will address it in a future version.

Add comment · Show 1

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

egomm · Feb 21 at 10:04 AM 1

Are you saying you cannot right click on a column heading and sort numerically? This functionality is available, this idea is just so the sort gets defaulted to numeric for numeric data

daleatsafe commented · Aug 15, 2018 at 11:50 PM

Hmm, I think this happens because much of the time FME does not know what the data type of a column is ahead of time. But that said, it feels like we could at least make an educated guess i.e. scan the first 1000 values and if they are all numeric go for a numeric sort. I'll see what the team thinks..

Add comment · Show 1

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

htl · Feb 18 at 07:09 PM 0

I am having the same problem described above in version 2018 and the latest beta of 2019 within the Data Inspector. It is kind of a pain when trying to determine the maximum string length for an attribute of a feature, especially when you have over a 1000 records! You have to scroll through each group of data, those starting with 1..., starting with 2..., starting with 3... find the maximum string length. A bit cumbersome. I cringe when I get to my exchange areas that have close to 10,000 records!

Automatically detect if sorting in Data Inspector is alphabetical or numeric.

2 Comments

Your Opinion Counts

IDEA DETAILS

Related Ideas