Welcome to the JMP User Community!

Latest Discussions

• JMP crashing from some combination of nested If(for(if())) loops, "string" || i for column reference, eval() -> expr(), and concat() + char()

  I feel like this is a simple question, but I can't for the life of me get this to work. The context is I have an XML extractor that frustratingly has to deal with n-tuples of mostly (aside from one row) redundant entries a couple levels into the structure. I'm trying to find those "duplicate" entries, and check if they are indeed duplicates before I import them into my larger table. I've got the c...

  ehchandlerjr

  Discussions |

  Nov 4, 2023 11:13 AM

  1541 views | 2 replies

• GraphBuilder Plot: Labels?

  Hi, I know how to enable Labels for Heatmaps:the labels are nicely aligned with the heatmap cells and the values correspond to the column values which are used as color. I also know how to enable labels for point plots - where the labels can be chosen independent of the "color" column: Is it possible to combine both approaches:
  Heatmap labels, where a column is used as labels which is NOT THE SAME ...

  hogi

  Discussions |

  Nov 4, 2023 1:40 AM

  3378 views | 7 replies

• Add a new column with a function similar to vlookup in Excel

  I'm trying to figure out how to add a new column to a table that will populate with data dependent on other data in that row. We have several fermentations in a data frame. Each one has a blank value. I'd like to have the blank value from each fermentation in a new column so that I can subtract it from the treatment value. Also if there's a better way to do this than creating a new column that wou...

  VarianceWalrus9

  Discussions |

  Nov 3, 2023 5:03 PM

  3216 views | 5 replies

• Failed to add text below Graph Builder using script

  Hi all, I recently updated from JMP 16 -> JMP 17 and the following script on line 5 is failing for me. I am not seeing the ' === below === ' below my graph builder. This used to work in JMP 16. Any ideas on what happened or what I am missing? Appreciate the help in advance!  

  yewhoo93

  Discussions |

  Nov 3, 2023 11:18 AM

  2103 views | 6 replies

• Format Date Time yyyymmdd_hhmmss

  Greetings, I am having an issue with a date-time format when save a csv file.
  The filename should be like "Summary_20231103_082637".
  
  formattedDate = Format(Today(), "yyyymmdd_hhmmss");
  filename = Convert File Path("C:\Path\Summary_" || formattedDate || ".xlsx", absolute );
  if(File Exists (filename),
  dt << Save (filename, Mode("Append")),
  dt << Save (filename));
  
  I tried to format the datetime with
  
  formatDa...

  Celine1

  Discussions |

  Nov 3, 2023 3:43 AM

  2073 views | 1 replies