Welcome to the JMP User Community!

Latest Discussions

• Split whole string into 2 new column

  table<< New Column("d0", Character, Nominal, Formula(Word(Column(table, "Data"), "_", 1, 3))); table<< New Column("d1", Character, Nominal, Formula(Word(Column(table, "Data"), "_", 4, 6)));
string= 1_1_1_1_1_1
  wanted to split this string into 2 column with data 1_1_1 for d0 and 1_1_1 for d1. Somehow the script above not working

  weilyne

  Discussions |

  Sep 3, 2023 12:52 PM

  914 views | 1 replies

• 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

  1411 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

  2659 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

  1465 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

  1324 views | 3 replies