Welcome to the JMP User Community!

Latest Discussions

• Open function with relative file location

  I need to use the open function with a relative file location. The following code finds the location, and stores the path to the file in the variable RelativeLocation relativePath = Get Default Directory(); UPtwo = Left( relativePath, Contains( relativePath, "/Folder/", -2 ) ); RelativeLocation = UPtwo || "Excel_file.xlsx";However, when using the Open function with the RelativeLocation variable, t...

  Steffen_Bugge

  Discussions |

  Sep 2, 2023 2:19 PM

  1646 views | 2 replies

• Distribution fitting given cumulative (quantile) data?

  Hi, I have data in the form of quantiles (percentiles actually) and would like to estimate distribution parameters and do a Q-Q-plot from that. I once used the Life Distribution platform for fitting but that only worked for probability data by using the probability as a frequency variable.  Maybe that's a trivial task in JMP but I don't see how I could do it.  Björn

  bjoern_arnold

  Discussions |

  Sep 2, 2023 8:30 AM

  3049 views | 4 replies

• I need to reorder my columns in an efficient manner (there are 57 instances of 5 groups each (57 x 5) = 285 columns to rearrange)

  Hi - I have 5 groups of 57 columns (5 x 57) that I need to rearrange so that likes are with likes.  I've cut and pasted examples of the columns from my JMP table.  The columns names have five sets of prefixes (again, each of these groups has 57 column names corresponding to chemical compounds):1 - RES_VALUES_2 - RES_TEXT_3 - DETECT_FLAG_4 - RL_5 - DILUTION_FACTOR_Each of these is followed by a suf...

  learning_JSL

  Discussions |

  Sep 2, 2023 5:13 AM

  1687 views | 2 replies

• Access to folder above main script

  I am currently using the Get Default Directory function to run a script in a subfolder of my main script, using the following code relativePath = Get Default Directory(); Include(relativePath || "Folder1/Data import.jsl");How can I run a script or open a file in a folder above my main script, i.e. in a directory higher than the full directory given by Get Default Directory function?

  Steffen_Bugge

  Discussions |

  Sep 1, 2023 11:49 PM

  1623 views | 3 replies

• Is there a way to group many rows into one row based on matching values of selected fields?

  Hi - I have a large dataset with individual contaminant compound results per row.  I.e. Each row has a lat, long, datetime, and a result for one of many compounds.  Instead, I need one row, and only one row, for each instance of lat, long, and datetime....that single row would then have ALL compound results on a single row.   In other words, I need to group by three fields (lat, long, datetime) an...

  learning_JSL

  Discussions |

  Sep 1, 2023 12:27 PM

  1627 views | 2 replies