Welcome to the JMP User Community!

Latest Discussions

• Import of 3 sheets from the same Excel file

  Hello all,I would like to import 3 sheets from the same Excel file in JMP.My Excel fil is encrypted with a password.If I import the 3 sheets (AAA, BBB, and CCC) with the following code (written 3 times), I need to write 3 times the password:Open( "/P:/XXX/TEMPLATE.xlsx", Worksheets( "AAA" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Co...

  Sebastienlg

  Discussions |

  Mar 19, 2024 2:47 AM

  1359 views | 2 replies

• 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

  5241 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