Welcome to the JMP User Community!

Latest Discussions

• Exporting Select Columns to CSV Filtered by Formula Column

  Hey everyone,  I'm new to JMP scripts and I'm hoping this may help others too.  From the sample data screenshot below (stored as a .JMP file), I'd like to select Material and Month and round Stock to a whole number.  I'd then like to filter only records where the rounded Stock calculation is greater than zero.  Finally I'd like the results to be saved as a CSV file.    Here is my initial attempt a...

  William_S

  Discussions |

  Jul 1, 2019 9:34 AM

  3781 views | 2 replies

• Set focus on text edit box

  HelloI try to check for an entry in a database with a barcode scanner.It will enter the number and gives an enter at the end whitch triggers the script of the "text edit box".What doesn't work is to reset the focus back on the box to enter the next number.Names Default To Here( 1 ); dt = current data table(); try(win1<<close window;); my_expr=expr( print(pnr << get text()); pnr << settext("")...

  Mauro_Gerber

  Discussions |

  Jul 1, 2019 2:49 AM

  5415 views | 5 replies

• New Sequence column creation based on another ID columns

  I've an existing column which has the Customer ID which occurs multiple times in the whole data table on a different date/time. I want to create a sequence such as 1,2,3 for each of the Unique Customer ID based on the date/time variable. How to acheive the same in JMP ?  Sample Data snippet (Customer ID | Date)ABC | 1-JUN-2019 XYZ | 1-JUN-2019ABC | 3-JUN-2019ABC | 4-JUN-2019XYZ | 7-JUN-2019 I want...

  venkateshc78

  Discussions |

  Jun 30, 2019 1:56 PM

  2467 views | 2 replies

• JSL- How do I get rid of quotation marks when saving to .mdf file

  The code shown below saves the data shown below into a .mdf file, however, I cant figure out how to keep JMP from writing the quotation marks shown at the beginning of the saved data.  How do I get rid of these quotation marks? DataCV=open("C:\Desktop\JMP\sample_data.csv"); Summarize( DataCV, processArray = By( :process ) ); For( m = 1, m <= Length( processArray ), m++, // Generates and saves...

  adjo9835

  Discussions |

  Jun 28, 2019 7:51 PM

  7157 views | 7 replies

• How to overlay two contour plots?

  Hello community,short and hopefully an easy question. I want to overlay 2 contour plots, how can I do that in an simple way?Please give me a detailed description, I'm totally new to jmp Greetings!

  marcokunzelmann

  Discussions |

  Jun 28, 2019 12:10 PM

  24098 views | 11 replies