Welcome to the JMP User Community!

Latest Discussions

• How do I automatically update JMP data table while populating Excel

  My purpose here is to is to link a JMP data table to an Excel spreadsheet. While Excel users populate the spreadsheet, I would like the data table to automatically re-populate (upon opening or continually while open) with the new data. I want to eliminate the need to recopy the new data each time eliminating any risk of copy errors and ultimately validating the population.  Is this possible and if...

  Jeff1

  Discussions |

  Feb 19, 2020 9:32 AM

  13318 views | 4 replies

• Using disallowed combinations in custom design

  Hi I am using JMP10 for an experimental design of protein expression in bacteria. I have many categorical factors and two continuous factors. I would like to exclude from the design several conditions that combine several values from one categorical factor with a continuous factor. Using the Data filter as explained here (Custom Design Window) I have generated an "AND" combination, and without fin...

  guttmanc

  Discussions |

  Feb 19, 2020 8:19 AM

  4522 views | 1 replies

• Difficulties Formatting Time Column

  Hi everyone!   I have a CSV of dates and times that I upload into JMP.  In order to create a single column with date/time I need to convert the data type and format of the column that contains the date.   When I use the script:   Column("Actual Harvest Time") << Data Type(Numeric); << Format("h:m")   It totally clears the column of any data.   I also learned that when I manually change the column ...

  user8421

  Discussions |

  Feb 19, 2020 2:55 AM

  2904 views | 2 replies

• Multivari chart combining means of variables

  Using the graph builder I would appreciate to come up with the a layout similar to below.   Graphbuilder let's me come up with something similar, but the relationship (the connecting lines) between categories is ‘artificial’, as in I drew them using the line option.   

  Zeban

  Discussions |

  Feb 19, 2020 12:02 AM

  2596 views | 2 replies

• JSL delete the entire column based on header and all rows with specific value

  Hi, I want to delete all columns that contain "apple" and delete all rows (regardless of columns) with specific value -9999. I had start the code to delete column but I'm not getting it. Thanks.   dt = Open("file.csv"); //dt = Open( "$SAMPLE_DATA/Cities.jmp" ); col_list = dt << get column names( string ); For( i = N Items( col_list ), i > 0, i--, If(Contains( col_list[i], "apple" ), Remove Fro...

  sam_t

  Discussions |

  Feb 18, 2020 8:26 PM

  7387 views | 4 replies