Welcome to the JMP User Community!

Latest Discussions

• How to script date of the current month for data compilation

  Hi all, I have the following code which does not work :// Current date aujourd'hui = Text(Today(),"00000000"); // Obtain the month number format "MM" numero_mois = Text(Month(aujourd'hui), "00"); // Obtain the year number - 1 format YYYY numero_annee = Text(Year(aujourd'hui) - 1, "0000"); // Concatenate the result date_debut_mois_actuel_Y = ("01" || numero_mois || numero_annee); // Show the re...

  Arkawa

  Discussions |

  Mar 19, 2024 2:18 AM

  5242 views | 10 replies

• Hide x-axis and y-axis number label

  Hello JMP community,   I am preparing my talk on the upcoming discovery summit.   Because of confidentiality reasons I cannot show the y and x-axis labels. See pic, where I removed the axis box via the properties visibility option.       Normalizing all the data to range 0 to 1 changes all the analyses I did with scripts. So as I see it, I need to keep the original (confidential) numbers but need...

  Benjamin_Fuerst

  Discussions |

  Mar 19, 2024 12:22 AM

  5585 views | 9 replies

• Projects and closing multiple dirty tables/scripts

  JMP Pro 17.2.0Is there a way to close what is selected in Project Workspace pane without the Save dialog for each individually?Or a way to identify what is selected in the Workspace pane to create a toolbar script button to close selected without saving or << Set Dirty(0) prior to closing? In the JMP Home Window List if you close multiple dirty windows it will let you "Save None". This would be th...

  ts2

  Discussions |

  Mar 18, 2024 2:55 PM

  1065 views | 2 replies

• Informat (ParseDate) function with time

  Hi, I have a question about Informat function (or its alias ParseDate). If I have a string with date and time information, and I try to parse date on JMP 15.2.0. str="2022-10-22 16:25:37"; datetime= Informat( str, "yyyy-mm-dd HH:mm:ss" ); show(type(datetime)); show(datetime);I get output different kind of outputs, depending on date time settings (Win 10). Regional format English (United Kingdom):
  ...

  jueefo

  Discussions |

  Mar 18, 2024 1:16 PM

  2683 views | 5 replies

• import of a Excel file with column name containing formulas

  Hello all, I would like to import an Excel file in JMP. However, the column name are formulas that allow to import names from another Excel sheet and it doesn't work. Here are the names of the imported column:Do you know if the is a way to import a such Excel file? Thank you in advance,Sébastien

  Sebastienlg

  Discussions |

  Mar 18, 2024 8:24 AM

  2659 views | 6 replies