cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar

Retain data when column data type is changed

Status: Acknowledged Submitted by Super User (Alumni) on ‎08-10-2021 08:08 AM
2 Comments (2 New)

When a column data type is changed, for example from character to numeric, make it possible to access the original data that was in that column, perhaps by storing a column script to revert that column.  This would alleviate several pain points:

  • Column is changed from character to numeric but user doesn't notice that a few values were set to missing until later in analysis.
  • User changes column from character to numeric, realizes it is wrong, tries to change it back, and then is missing data.  They might or might not notice this now, but even if they do it is not obvious and very inconvenient that they need to keep hitting undo to fix it.
  • Data is automatically typed as numeric or character when it should have retained is original format, as in this post: Stop JMP from trimming whitespace 
2 Comments
nao
Level IV
‎08-30-2021 11:06 AM
‎08-30-2021 11:06 AM

I assume Character Columns are frequently converted to Numeric ones, often leading to issues including the one described here.

I would suggest:

1. When a Character Column is converted to a Numeric Column, a warning should be displayed, saying "This will cause an irreversible change. Data in XXX out of XXX rows will be set to missing because of non-missing but non-numeric data. Will you rather create a New Numeric Column?"

2. Provide a GUI option, preferably with a corresponding JSL function, to create a new Numeric Column along with another Numeric (binary) Column indicating whether the Character data has been converted to a number. (For example, 1=Character string has been converted to number, 0=Character string present but not converted to number, .=Null string, etc.) Coloring cells may also be useful.

3. When a Character Column is converted or a text data is loaded, provide an option to let JMP "smartly" select the optimal number of subdecimal digits to be displayed (Format - Fixed Dec).

4. Stop interpreting "x.x.x" Character strings (three numbers separated with periods) as numbers, unless it is explicitly demanded by the user.

Sarah-Sylvestre
Staff
Staff
‎12-07-2022 05:28 PM
‎12-07-2022 05:28 PM
Status changed to: Acknowledged

Hi @ih, thank you for your suggestion! We have captured your request and will take it under consideration.