JMP Wish List

What inspired this wish list request?  ☐ cool new feature ☑ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2023 (either this one or Tables join: option to update main table ) we have a workaround -> we don't need it anymore   Tables Update is a really nice Platfrom which can be used to merge columns into a data table or to update columns with the data from another data table. But sometimes the user has to wait for a long time till Jmp finishes a data table update - even with medium large data tables.   Sometimes, Jmp already gets stuck while editing settings in the Update GUI. Then it seems that Jmp crashed - , but after some minutes (or sometimes:  hours), Jmp finishes the calculation for the data preview and gives the user again the chance to edit the settings. It's clear that it takes a while to match hundreds of thousands of values in one table with values in another table. But I am surprised that merging two columns takes twice as long as merging one column Is the matching step triggered again for each column that is merged - or is it actually the sorting of the values which takes so long?   Often, I don't have unique identifiers in the source table: a single match value shows up several times in a column - with identical values also in the column to be merged. In this case, I wonder if the value of the first match is entered to the target data table, then replaced by the second  - and so on ... This could be accelerated by searching the last matching value in the source table - and just inserting this value.   A big drawback of the Update Platform: It starts with add columns and replace columns activated. If a table has e.g. 1000 columns, it takes a while till all columns are added to the preview window. The issue scales with rows_main     x     rows_2nd    x    columns_2nd. And as stupid as I am, I often start by defining the match columns ... which allows me to go for a long walk till I am allowed to pick the (1-2) column(s) I actually want to add to the table. There is a functionality which disables the preview if the table is too large. But I fear that the function just checks the length of the table -  and not the number of columns. Or the threshold is too large?   Please share your experience - how often you had to fill the time till your Jmp session was back again after an update of the preview tab.   Another issue is the Recall Button (addressed here: Disable Preview while filling the GUI via Recall  ) After clicking on Recall, the Update menu is filled with the saved settings - and after each change of a GUI setting there seems to be an update of the preview tab. So if you want to join large data tables - even if you just want to add a singe column - don't dare to press Recall ... before you disable the preview.   What is the improvement you would like to see?  Could you please improve the performance of Tables/Update.   Why is this idea important?  Tables/Update is a wonderful function. The Preview Tab is amazingly useful, I don't want to work without it. But I'm starting to get paranoia - how long will it take the next time when I try to add columns to a data tables. ... View more

What inspired this wish list request?  Testing results very often include non-numeric entries such as "N/A" or "Nil" in columns consisting of otherwise continuous numeric data. This causes JMP to class it as "Character" data, resulting in the need to recode and then reclassify the column.   What is the improvement you would like to see?  I'd like JMP to be able to bring up an error message to say: "Column X's data is continuous and numeric apart from rows 35 ("N/A") and 37 ("Nil"). Would you like to change these to numeric entries?" "Yes" would then bring up a window where I could recode these two rows and it would automatically be classified as continuous numeric.   Why is this idea important?  It's easy to stick to rules for data recording if you're generating and doing the recording yourself, but if you're contracting out or getting help from others, these errors can sneak in (and I suspect they're pretty common!). This sorts of studies tend to have large data sets and to be able to work with the data without having to recode would be ideal.   ... View more

Hello, When porting the output data from Matched Pairs to a (combined) data table, the various parameters are split into multiple columns. This makes the data cumbersome to use. It would be preferable for the various parameters (Mean Difference, DF, t-ratio, Prob > |t|, etc.) to be put into separate columns (with the appropriate column headers). Alternatively, they should be tabulated as stacked, with the headers in a Label column and values in a Data column. Once the data is available in one way or the other, it can be handled more easily. With the current approach, it's neither here nor there.   Regards Mehul Shroff ... View more

What inspired this wish list request?  Currently, within the Concatenate function, columns to be concatenated have to have exactly the same header (including case). Frequently, there are small differences or typos which JMP interprets as being a different column. This can be rather frustrating and slows things down.   What is the improvement you would like to see?  The concatenate function to have an extra window where the user can state which columns are matches for each other (I'm thinking it could be something similar to the Group function within Recode)- for each file you're concatenating you could have a list of columns and you could select your columns to match and click a "match" button. If JMP could suggest matches (and show its suggested matches) before producing the new data table that would be useful too (and help catch the odd typo)   Why is this idea important?    It smooths out the Concatenate process and saves you time instead of having to change all your column headers to exactly match.   ... View more

What inspired this wish list request?  Multiple file import and open functions are able to save a list of files they open in a list. I'd like to see something similar with functions that can generate multiple columns from one, mainly text to columns    What is the improvement you would like to see?    saving text to column to a variable saves a list of column names generated to a list.   Example: A dt containing a column of numbers separated by commas new_cols_list = dt << Text to Columns( columns( :Numbers column ), Delimiters( "," ) );   Why is this idea important?  This would allow more compact identification of generated columns, and therefore more streamlined, and less error-prone way of working with these columns, if needed   ... View more

What inspired this wish list request? Imagine you have a list of credit card transactions from all your daily expenses and you want to recode those individual transactions into a new column of categories (Groceries, Dinning, Shopping, Public transportation...). Each of the transactions has a piece of the string that is recognizable and another piece which changes for every transaction (Walmart 637746556, Walmart 784767663, Target 6778356, FavRestaurant 736654, PizzaPlace 76354, PizzaPlace 78294...). To use the recode platform for this task, you currently can: - Manually group the transactions - Use Replace String with the "Replace entire string" option to replace all the "Walmart" containing strings with "Groceries". You would need to do this for each string manually and open the Replace string window every single time. What is the improvement you would like to see?  I would like to have a hybrid between the Replace String function and the Apply Mapping From Table function. This would consist on a table selection dialog where I can select a table that contains a column with my desired "Replace String" value I want to match and a second column with the value I want to replace the full string with. If I had the following two check boxes in the existing Apply Mapping From Table function: - A checkbox to tell the platform to "Find string" instead of "Matching the value" - A checkbox to tell the platform to "Replace full string" instead of replacing the "matched substring" That would meet the need. Ideally, this recode would be saved as a formula in the shape of regex or something similar so when new data is added, it can auto update the recodes. Why is this idea important?  This would be a big improvement in the speed of recoding using the recode platform for non-coders.   ... View more

What inspired this wish list request?  The new Data Preview in the Tables Platforms are extremely useful. The same holds for the Recall button.   Unfortunately, there is a conflict between both functions: After a click on the Recall Button, the GUI interface is filled with the stored values - step by step for every single entry. And every single GUI update triggers a Auto-Update of the Data Preview. No big issue - but as Replace Column Values is set to All by default (?!?!), there are cases where a Replace doesn't work - and Jmp throws an Alert - step by step with every single update of an entry. In total: 10 error messages.   What is the improvement you would like to see?  Please disable the auto-update of the Preview till all GUI items got updated by the Recall button   Why is this idea important? With the proposed improvement, the user will see the Alert just once - not 10 times.     ... View more

What inspired this wish list request?  Sometimes a user wants to replace values of a column with  the value labels, ("apply" the value labels to the column and remove the value column label property). For Formula column, the user can click on Remove - then the values stay as they are - and the formula is removed.   If the user clicks on Remove to remove the  Value Label Properties, the values jump back to their original values - and just the replacement rule is removed. This behavior makes sense - but sometimes a user wishes the Remove button behaved like the Remove column formula button.   One example:  to get the possibility to change individual entries of the column (via Recode, for a subset).   An experienced user knows that deep in the Recode menu there is a function Replace values with value labels: https://community.jmp.com/t5/Discussions/quot-apply-quot-value-labels/m-p/628420/highlight/true#M82677  Without this experience a user can search a long time - without finding the function ...   What is the improvement you would like to see?  Provide Replace values with value labels (apply + Remove) directly in the Column menu:       Why is this idea important? It's not important.         more wishes submitted by   ... View more

What inspired this wish list request?    More intelligible table names when the option "Subset by" is used. Consecutive numerical naming, along with the deletion of the Subset by column creates datasets that have had data deleted and can be difficult to name properly.   What is the improvement you would like to see?    An option to append the data that has been appended into the subset name.   For example:  If I have a data table that includes a column :Fruit of fruit names and I want to create a subset for each fruit (given the output name of "Fruit"), right now I'd use --> subset > Subset by :Fruit. This would output data tables that have the name "Fruit 1", "Fruit 2", etc.  The data of which fruit each data table has been created for has been lost, since the column with this information has been deleted in this process.  I'm suggesting the following:   If I have a data table that includes a column :Fruit of fruit names and I want to create a subset for each fruit (given the output name of "Fruit"), right now I'd use --> subset > Subset by :Fruit. This would output data tables that have the name "Fruit Apple", "Fruit Orange", etc.   Why is this idea important?    This would help keep information, rather than deleting it, creating predictable output tables names for calling later in scripting for further processing.   ... View more

Hello, Can the functionality of Compare Data Tables be extended to allow comparison of more than two data tables at a time? In the interim, is there a workaround to enable this? In my current use case, I'd like to compare changes across three data tables. Thank you. Regards Mehul Shroff ... View more

Hello,   I would like to request a function to be added to the Rows menu to delete duplicate rows based on a matching cell except for the first (or selected) one. Currently, one has to first select matching cells, unselect the first occurence, and then delete the remaining. In a large dataset with several unique sets of duplicates, this can be extremely cumbersome.   Thanks and regards Mehul Shroff ... View more

Row functions are essential in manufacturing data.  We use Dif() to calculate the rate of change (slopes, or derivatives), which can be correlated to our target of interest. Lag() is also used to align data (upstream and downstream equipment)   However, when having tables with a column indicating different groups, new users are out of luck.   Two consecutive rows can belong to different groups and the only way to guarantee this is by adding complex formulas with conditionals (example).   It will be much easier for the user to include a <byVar> argument in Dif() and Lag().   For example, Col Cumulative Sum() is another row function that does allow this!   Here, I am creating a simple counter where I don't need to be worried about conditionals.   ... View more

Hello,   It would be helpful to add an option to the Tables -> Subset dialog to allow a user to include the row #s of the original dataset that are included in the subset.   Regards Mehul Shroff ... View more

What inspired this wish list request?  Data table with columns that are used in groups that are not mutually exclusive.   What is the improvement you would like to see?  In the columns pane, in addition to being able to group columns it would be nice to have virtual groups that are not mutually exclusive.    Why is this idea important?  This helps to make sure that the intended columns in a large table are used as planned.     ... View more

What inspired this wish list request?  The Filter menu in the column list is very useful. The user just has to add tiny identifiers to the column names to get a handle to select a set of columns (much more flexible that grouping :). For larger data tables, it could help to have an automatic way to add strings to column names.   What is possible at the moment: - use JSL: https://community.jmp.com/t5/Discussions/Append-a-string-to-column-names/m-p/614825/highlight/true#M81470  - use Rename Columns from the Jmp Scripting tools Add-In: https://community.jmp.com/t5/Discussions/Append-a-string-to-column-names/m-p/614760/highlight/true#M81465    Unfortunately, the two approaches are not recorded in Workflow Builder. The user has to script on his own. @Jed_Campbell found a very creative way to achieve the task with steps which are recorder by Workflow Builder: https://community.jmp.com/t5/Discussions/Append-a-string-to-column-names/m-p/614826/highlight/true#M81471 This is can be seen as a proof that "actually it is possible" - but less as a viable way which you would suggest your colleagues after 2 weeks with Jmp.     So, under the line, at the moment there is no easy way to achieve the task.   What is the improvement you would like to see?  Please steal some ideas from Scripting Tools /Rename Columns  and add them to std. Jmp. especially:     A similar option could also be added to the Recode function -.   Why is this idea important? It's not - just an improvement of Jmp which will help the users to change column names and entries in a more flexible way.         more wishes submitted by   ... View more

What inspired this wish list request?  I have many files that I need to merge them. They are all in excel and they have the same name columns if the comparison of the tables had a button this could facilitate the life to check if there are any mistakes or even the possibility to do a matching button for the ones that are not the same spelling...Also, the possibility to add more comparison tables instead of only 2.    This improvement could make it easier merging tables from different files and multiple ones. Helping researchers to do a bigger data bank.      ... View more

-What inspired this wish list request? We keep having a problem with imported data not matching JMP's default character set. The problem occurs when we manually create a table and then try to join to existing data and nothing matches.    What is the improvement you would like to see? To be fair, you could argue this is an issue with the source data. However, it is hard to detect as the names can look exactly the same. It would be good if JMP could alert to such a situation and ask which character set to use or automatically convert to JMP default on import, remember the character set, and give user option on which character set to use on export. And/or provide tool in compare data tables that can identify differing character sets, and/or provide function that change character sets.   Why is this idea important? The issue occurs too easily and is hard to detect because there is no visual difference in the characters.     ... View more

Hello,   When using the Table-processing commands, it would be helpful to provide checkboxes in the dialog to determine how to handle hidden / excluded rows or columns. In particular, this is problematic with splitting tables.   Regards Mehul Shroff ... View more

☑ cool new feature ☐ could help many users! ☐ removes a "feels like bug“ ☐ nice to have ☐ nobody needs it      What inspired this wish list request? If a user clicks on column/right click/new formula column/Transform/Scale Offset, a GUI pops up and ask the user for the parameters.  After pressing OK, a new column is generated with the respective rescale parameters:   This is very useful. But there is no possibility to add user defined mini,GUI, like a   column/right click/new formula column/Transform/Modulo shortcut to calculate Modulo the same way.   What is the improvement you would like to see?  Please provide a functionality to gererate mini GUIs such that a user can add slightly more complex functions to the column/right click/new formula column menu which need a GUI.     Why is this idea important? There are many wishes for additional functions to be added to the Column/right click/new formula columns menu, e.g. add modulo to the NewFormulaColumn menu   @mia_stephens  suggested to generate the functionality on my own: https://community.jmp.com/t5/JMP-Wish-List/add-modulo-to-the-NewFormulaColumn-menu/idc-p/594368/highlight/true#M3734 (unfortunately, without a hint how to do so). There was also no feedback from the community how to do it: https://community.jmp.com/t5/JMP-Wish-List/add-modulo-to-the-NewFormulaColumn-menu/idc-p/596340/highlight/true#M3749  So, I think that the needed functionality is missing.   With the possibility to generate user-defined mini-GUIs, users can add the functionality on their own and don't have to convince Jmp Dev Team to add the function.         more wishes submitted by   ... View more