Welcome to the JMP User Community!

Latest Discussions

• 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

  5645 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

  1603 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

  7911 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

  2153 views | 2 replies

• How to pick data Quantiles in Distribution?

  Hello, i'm making the contour plot using the data in Distribution, Quantiles 75% & 25%. My question is how do i put the data Quantiles 75% & 25% in my Minimum Maximum Contour Values? All the data Quantiles is different from another data.
  
  //Put the spec limit on parameter into current data table Names Default To Here( 1 ); dt = Current Data Table(); // Get the all column names from the data table c...

  mystylelife19

  Discussions |

  Aug 8, 2023 5:44 PM

  2824 views | 2 replies