Welcome to the JMP User Community!

Latest Discussions

• Custom design question

  I'm creating a DOE and haven't in a long time and I can't remember, For continuous levels you input low and high (-1 and 1) and when you make your design it generates different runs. So 3 question, if my variable is temp 50 to 100, how does my model explore temps between (if it's include center points how do I judge how many with such a sliding scale?). Also if my goal is to hit a target (say a di...

  hallef18

  Discussions |

  Aug 9, 2023 3:41 AM

  896 views | 1 replies

• How to save CSV file with custom text before headers

  There is a way to import a csv file where headers start not from the first line. You just specify the on what line the headers are. But let's say after I did something with the data table and I want to export it back to the same format, how would I do that? Let's say I have the text, and it is just one line.So that this CSV in Excel looks like this:and in a Notepad it looks like this: Is there a c...

  miguello

  Discussions |

  Aug 8, 2023 11:17 PM

  4012 views | 5 replies

• Parse in substitute

  In Substitute, if I don't have a fixed number of symbols, is it possible to use a for loop and parse to generate the symbol names?Something is wrong here: myExpr=Expr(sum()); For( i=1, i<=10, i++, Insert Into (myExpr,parse("__x"||Char(i)||"__"))); Show(NameExpr(myExpr)); For( i=1, i<=10, i++, substitute (Name Expr(myExpr),parse("__x"||Char(i)||"__"),parse("y"||Char(i)))); Show(NameExpr(myExpr));

  hogi

  Discussions |

  Aug 8, 2023 11:04 PM

  1012 views | 2 replies

• Get the value from a given column on the first selected row using JSL

  I'm trying to simply get the value from a given column on the first selected row -- but somehow this is surprisingly hard.  Here's what I have so far: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Probe.jmp" ); dt << Select Where( :Wafer Number == "16" & :Die X == 3); selRow = ( dt << get selected rows() )[0]; Row() = selRow; site = :Site; // returns "1", should return "5" (:Site from ro...

  BHarris

  Discussions |

  Aug 8, 2023 8:38 PM

  6051 views | 6 replies

• Data time format while importing excel sheet

  Hello JMP users, I am trying to import an excel sheet which have two different type date-time format. (screenshot attached below)After importing in JMP format looks like below: Can you suggest how to fix date-time format while importing excel sheet in to JMP table. Thanks, 

  chandankishor66

  Discussions |

  Aug 8, 2023 6:47 PM

  996 views | 2 replies