Welcome to the JMP User Community!

Latest Discussions

• 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

  1468 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

  1326 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

  1429 views | 2 replies

• step

  The step function looks useful   some things which I noticed: 1) Don't use string values  as yi - although it seems to be "allowed": 2) Description - add-on:
  Returns the yi argument corresponding to the largest xi which satisfies xi less than or equal to the x argument- but only: IF there is another xi that is larger than x. 3) None of the yi values must be empty.
  
  
  Names Default to Here(1); dt = Open...

  hogi

  Discussions |

  Sep 1, 2023 9:16 AM

  1228 views | 2 replies

• Centre point vs factor level

  Hello:I am studying a DOE textbook and in one example there are two factors with two levels.A 2^2 experiment is set-up with 5 center points. There are no replicates or blocks. In total 9 runs My question is what is the benefit of CP, why not a two factor experiment with three levels, In total 8 runs Q1) Which scenario is more beneficial?Q2) Are there any cases where we should use CP and where we s...

  VarunK

  Discussions |

  Sep 1, 2023 5:32 AM

  1985 views | 5 replies