Welcome to the JMP User Community!

Latest Discussions

• Prepping list column names for future use

  Hello, I'm trying to retrieve and prep a list of column names to save in a variable to use later. The issue is that << Get Column Names() returns everything as a list of strings. Below is how I've added in a " : " to the beginning of each item string and what a potential usage of this may be. More still needs to be done. names default to here(1); dt = current data table(); col_names = dt << Get C...

  StarfruitBob

  Discussions |

  Nov 15, 2022 9:05 AM

  1634 views | 3 replies

• JMP doesn't recognize year from date column when importing Excel to JMP table

  I have an Excel worksheet with date column where the date is shown as D-MMM.When I imported this worksheet to JMP using Excel Import Wizard, JMP recognize only D-MMM After I have edited the column format from <D><-><MMM> to be <D><-><MMM><YYYY>, JMP thought that the <YYYY> is 1904 (default year) What should be the better way to fix this? I can only think of two ways currently, not sure if there ar...

  Nita_Natchanok

  Discussions |

  Nov 15, 2022 7:14 AM

  5209 views | 7 replies

• How do I turn off "open with default program" when opening csv files?

  Hello everyone, Every time I try to open a new csv file in JMP, this is the default.Does anyone know how to make this unchecked by default?  I have never wanted to use JMP to open a file in Excel. Many thanks, John

  JohnDMoore1

  Discussions |

  Nov 15, 2022 5:32 AM

  1949 views | 2 replies

• Case Insensitive searches using contains

  I am using the following piece of code to check if the list cn contains "col_name" and if yes rename it as Target.The problem is col_name can be all upper case or lowercase and there is no way for me to control that.How do I make sure that the code gets executed irrespective of the case?   If( Contains( cn ,Lowercase("col_name") ), :"col_name" << Set name("Target"); );   Thanks

  ENTHU

  Discussions |

  Nov 15, 2022 12:43 AM

  4351 views | 4 replies

• process DOE which option is better and why - small batch or split plot for larger batch

   Hi,i would like to design DOE for the following situation:The process has 3 steps.  option A - in step 1 prepare a small batch of 100g and continue with that to the next steps. each batch per one DOE run. this means that all the parameters would be easy to changeoption B - in step 1 prepare a small batch of 500g and continue with 100g out of this Big batch to the next steps - this batch will last...

  YanivD

  Discussions |

  Nov 14, 2022 6:47 PM

  2848 views | 6 replies