JMP Wish List

I would like to have new column property (or modification to existing one) which would allow me setting upper/lower limits and then all the values outside those limits would be treated as missing values. I have situations where I have hundreds of measurement columns. In some rows single value might be a failed measurement and to easily exclude it from analysis I have two options: Exclude whole row, but this will make me loose measurement data from all the good measurements also Stack the data and handle those situations row by row exclusion. This will make it much more difficult to use some of the JMP platforms, column switcher, data filters and so on. My suggestion is to add column property which I could use to "exclude" (treat as missing) those values from single column. This way I could fairly easily loop over the data and set my limits. Maybe setting this column property could also be added to Explore Outliers platform.   Edit: So something like this but without formulas: Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); Column(dt, "height") << Set Property( "Missing Limits", {50, 65} ); key = "height"; m_temp = Column(dt, key) << get values; Eval(EvalExpr(Column(dt, key) << Formula( m = Expr(m_temp); If((Expr(Name Expr(As Column(key))) << Get Property("Missing Limits"))[1] < m[Row()] < (Expr(Name Expr(As Column(key))) << Get Property("Missing Limits"))[2], m[Row()] , . ); ))); wait(1); Column(dt, "height") << Set Property( "Missing Limits", {59, 61} ); dt << Rerun Formulas; wait(1); Column(dt, "height") << Set Property( "Missing Limits", {50, 65} ); dt << Rerun Formulas; ... View more

Add-in to automate data extraction tasks from Aspentech IP.21 and Osisoft PI (Aveva) historians. This way, you can use JMP to diagnose manufacturing problems and monitor several tags daily and weekly.   For example: MES data retrieval add-in - Aspentech IP.21 and Osisoft PI (Aveva) https://community.jmp.com/t5/tkb/workflowpage/tkb-id/add-ins/article-id/1589     ... View more

Hi.  I propose there should be an optional argument that forces all columns to be Character Data Type for both the Open() and Multiple File Import() commands.  This request is similar to, but not exactly the same, as these 2 requests:   https://community.jmp.com/t5/JMP-Wish-List/Excel-Import-specific-column-types-or-formats/idi-p/248136  https://community.jmp.com/t5/Discussions/Force-column-from-CSV-import-as-Character-not-Numeric-Date/m-p/260752#M51078    The first link requests the ability to manually specify column data type for Excel files in the Open() GUI, whereas my request is addressing usage of the Open() command in a script, not the GUI, and applies to both csv and xlsx files.  The second link appears to apply only to MFI() and csv files, whereas, I would like this ability for both MFI() and Open(), and for both csv and xlsx files.   I realize there exist various scripting methods that could do this for certain scenarios, although not all. Some of these methods might require you to know the column names/locations in advance, or require that the column names always be on the first row.  This is not something we necessarily have control over.     I feel having a single option to set would simplify this greatly for many users.  Also, this would save time since JMP would not need to spend time scanning the file to detect column data type.  Lastly, my feeling is that this could be low-hanging fruit to implement, in that you'd just be turning off the portion of the internal code that scans each column.   Hope this is possible.  Thanks. ... View more

Currently we can use "open multiple" to open multiple .csv Excel files with same format and combine to 1 single file, however, this function seems not applicable for other Excel format (xlsm, xlsx, xls, etc.). Besides, the import settings is also only applicable for .csv document. Can JMP make changes to support for all Excel document format?     ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   I oven have to import a few different types of csv files: - different number of header lines - different field separators - point and comma as decimal separator :) - different file extensions   My wish: a possibility to save presets in the multiple file import menu. Then I could quickly select the correct settings by a single mouse click.   other wishes submitted by       ... View more

It would be extremely helpful to have a built in function to convert a time stamp between time zones using the tz database (more info: https://data.iana.org/time-zones/tz-link.html and https://en.wikipedia.org/wiki/Tz_database).  I regularly need to convert time stamps from one time zone to another, but can't simply apply an offset, but it is time consuming to have to look up the offsets to convert the time stamp.  Additionally, there is extra work required since certain locations have daylight saving time and others don't, and daylight saving time start/end dates are location specific.   This function could be something like this:   ConvertTimeZone( ts, tzFrom, tzTo ) //ts is the time stamp will be converted from tzFrom to tzTo //example ConvertTimeZone( 05May2022:19:31:07, "UTC", "America/Los_Angeles" ) //result: 05May2022:12:31:07     Ideally, all datetime values would be changed to contain the time zone, and be set to default of UTC, if not specified.   Each time zone should use the TZ database name (https://en.wikipedia.org/wiki/List_of_tz_database_time_zones), as is used in other programming languages (e.g.: Python).   Here is a question about this issue: https://community.jmp.com/t5/Discussions/Time-zone-conversion/m-p/331514#M58032   For a very humorous description of the time zone issue, watch this video: https://www.youtube.com/watch?v=-5wpm-gesOY&t=3s. It is 10 minutes long, but well worth the *time* (pardon the pun). ... View more

JMP 16.2 Query Builder does not allow for multiple OBDC connections to MySQL schemas within one query.  If I choose a DSN connection and then select the table as t1, I cannot choose a second DSN connection to another table in another schema within the same query build.  It would be very useful if Query Builder could perform this function. ... View more

In an usual Single File import it is possible to set "Regional Setting" to avoid "Dot" or "Comma" issues with numerical values.   It would be great if that could be available for Import of Multiple-Files.   Thanks! Best regards, Tanja JMP 16.0.0 ... View more

Allow users to use a list with Select Rows platform. From time to time I have to do this and depending on what type of list I have, I use different approaches: script it, use join, create formula... and it would be helpful to be able to do it directly from menu.   User would have to be most able to copy and paste values from excel and jmp (and other possible lists). So might be helpful to allow user to also provide a format how the list should be formed. ... View more

☐ cool new feature ☐ could help many users! ☐ removes a „bug“ ☑ nice to have ☐ nobody needs it other wishes submitted by     The idea: if there is no unique identifier for virtual join -- add the possibility to define an aggregation to generate unique values.   no need to have a unique identifier for virtual joins anymore a default option for data aggregation ["median" would be cool, but just works for numbers; so the not so useful "N"?] + a possibility to define the aggregation individually for each column (like in the query builder) the benefit: the aggregation option makes the virtual join much more versatile the virtual join is almost as "dynamic" as the link functionality of summary table (<->  Query Builder) virtual links survive after the data is saved and re-opened (<-> link table) the disadvantage: the aggregation will slow down the virtal join.   the woraround: aggregation via summary table join via virtual link important: save as a script (to establish the dynamic link again after it got lost after saving the file) ... View more

It would be nice to be able to launch the Import Wizard as one of the functions in the Excel add-in (most Excel files need some cleanup in one form or another before further analysis). Currently using JMP 16.2 Pro. ... View more

I like to use the import wizard to get Excel data into JMP (version 16.2 Pro); this works fine for files stored on LAN but I don't seem to be able to use the wizard to open files stored in Teams/SharePoint. Can this functionality please be added? ... View more

☐ cool new feature ☐ could help many users! ☐ removes a „bug“ ☐ nice to have ☑ nobody needs it -> use Query builder.     Hi, when joining tables, it gets interesting when there are several rows with identical values to match. The standard approach: for the N idential values in the first table and M identical values in the second table, NxM rows are generated in the joined data table.   Another way is to use the "drop multiples" option. Then just the first row with the respective value makes it into the joined data table and the remaining rows are dropped.   my wish: an option to choose the aggregation method (one drop-down menu for each of the 2 tables)   possible options: the two existing ones: - no aggregation, NxM - take the first, drop the rest ... plus some of the aggregations that can be found in the Summary Table menu  (at least: N, mean, median, min, max, sum) A workaround: first, generate a summary table for one table - and then joint the summary table with table #2 -- or a summary table of table #2. another workaround: generate columns with the aggregated values first and then join the tables   but it would be really cool and convenient if this could be done directly via the join table menu ... ... View more

When an excel table contains break line (ASCII CODE Alt+010) in some cell, the copy paste feature creates several row.  Removing break line in the excel file is somehow difficult and change the layout. It would save a lot of time and effort if JMP would deal with break line by enabling break line in the title of column or by replace them by any ponctuation character when pasting. ... View more

☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it An everyday problem in daily jmp data handling is how to get updated data sets efficiently into jmp: You add some lines to an excel file - perhaps also some columns - and want to check the graphs that you just have generated in jmp.   When importing csv or excel files, a "source" script is added atomatically - and one could run it again to get an updated version of the data into jmp. But the new data is imported as a second data set - independent of the first one. So, if there are already dozens of graphs, analysis windows and dashboards linked to the original table, it's quite some effort to update everything.   I'd love to have a universal "update" button that copies any update of the input (e.g. Excel) data to the jmp table: - adds new rows - deletes removed rows - adds new columns (keeps previous columns, even if they were deleted  - just in case :) like the "reread" button in Cornerstone.   A first step in this direction and very helpful is Martin's "update from Excel" script: https://community.jmp.com/t5/Martin-Demel-s-Blog/Updating-a-JMP-data-table-from-a-spreadsheet-made-easy-Part-1/ba-p/266323 ... but some of the above functions are missing. And:  The script should be added automatically - like the "source" script, right?     ... View more

Allow joining two data tables based on not exact matches. I come across situations where I have to be able to join two databases (tables) together based on timestamp which aren't exact matches. This would allow me to do it based on those timestamps. The joins could also be based on string-similarities but I haven't (yet) come across situations where I would need to do that.   Continuous column join should let user to define tolerance and allow using grouping column(s).   Below are some example packages, which can provide some ideas on what type of joins and options would be helpful: Simpler package could be similar to Pandas - merge_asof . More complicated join options could be found from R - fuzzyjoin: Join data frames on inexact matching which allows joining based on multiple different matching types (string similarity, regex, numeric values within tolerance) There are couple of scripts found from JMP Community which can do this (or parts of this), but it would be helpful to have this possibility directly built in JMP: "Fuzzymerge" - join tables with slightly different timestamps by @klk  Join Nearest Rows - Join tables by using continuous columns and nearest values by @jthi (me) ... View more

Excel import wizard is very useful, but if your first row is blank it will sometimes treat the column as numeric and empty the data. Changing the column type in the wizard (JMP 17EA) doesn't cause a re-import, and running the table macro with the column specified as character doesn't solve the problem (appears it imports and then changes).   Suggestion:  either allow 'import all columns as text' (or perhaps 'preserve all cell contents'), or something that allows you to restart the import process after assigning data types to columns. ... View more

Hi, I want to use the Import multiple files ..." to load csv files with slightly different structures: therer is huge overlap of columns, but some files have columns which the others don't. In this case, the import seems to stop if a deviation is detected in a file.   my Wish: the program loads all files and there is a control to choose: - just load columns that are available in all files - load all data (and accept that there is no data for part of the files)   Thanks,   Holger ... View more