Welcome to the JMP User Community!

Latest Discussions

• Formula to check if any of a list of items is contained in the rows of a column

  JMP for Mac Version 17.2.0 (701896) I have a column "Data" with rows of number_number like this:1_33_76_5... I want to test this column to see if some of the rows contain values from a list of values and then flag or label the rows which do. I know I could construct an elaborate formula like this:If( :Die X_Y == "3_9" | :Die X_Y == "3_4", 1, 0 )But that's very laborious for long lists of differe...

  datanaut

  Discussions |

  Dec 3, 2025 12:08 AM

  4593 views | 15 replies

• I am generating new column based on a user input and need to move

  I am generating new column based on a user input and need to move using script. Can anyone help to fix my script dt << New Column("Suspected "|| selectedCol, Formula( If(Contains(myValueList, char(as column(selectedCol))), "Yes", "No" ) ) ); Data Table( dt ) << Move Selected Columns( as column("Suspected "|| selectedCol), after( as column(selectedCol) ) );

  ConfidenceOwl94

  Discussions |

  Dec 2, 2025 9:47 PM

  164 views | 4 replies

• JSL coding debug - help needed with "Label"

  Hello,   In my JSL code, I am using  dtt<<Set Label Columns (:skew); and I can see in the table that label icon is being added next to skew. Then I am using graph builder and within that routine, I have  Show labels(1), But when plots are being generated, it is not showing Label. Can you please help on this? Do I need to add anything else?   Thanks much

  hasanurkhan

  Discussions |

  Dec 2, 2025 2:19 PM

  843 views | 17 replies

• Keep Leading Zeros

  One of the columns in my data set is Employee ID. All employee ID's have a length of 8 and begin with leading zeros. When I open the excel file that has the data JMP seems to drop those leading zeros. Is there a way to get JMP to not do that? Or does it have to do with the way that column is stored in the xlsx file? I tried using the code I found on here to just add them back in but it added them ...

  ACraig

  Discussions |

  Dec 2, 2025 1:30 PM

  3397 views | 3 replies

• No Module named 'pandas'

  I’m running a JSL script in JMP 18 that uses Python. On macOS everything works fine, but on Windows I get this error: Traceback (most recent call last): File "<string>", line 7, in <module> ModuleNotFoundError: No module named 'pandas'
  
  In the embedded log is see following: Creating: C:\\Users\\Admin\\AppData\\Roaming\\JMP\\JMP\\Python\\Python311\\site-packages This tells me that JMP 18 doesn't ...

  zetaVagabond1

  Discussions |

  Dec 2, 2025 11:28 AM

  371 views | 6 replies