Welcome to the JMP User Community!

Latest Discussions

• Generate new column (string) with compose of the same ID in different rows and excluded duplicate string

  Hi, I want to generate a new column that combines the strings in the same ID in different rows as the example table (I want column results). Thank youIDAbresults1A2, B3A2, B3, B56, C7, DR51A2, B56, C7, DR5A2, B3, B56, C7, DR51DR5A2, B3, B56, C7, DR52A56, B9, C0, DQ89A56, B9, C0, DQ892 A56, B9, C0, DQ892DQ89A56, B9, C0, DQ893A2A2, DR53DR5A2, DR53 A2, DR5

  doraemengs

  Discussions |

  Jul 27, 2024 12:23 AM

  779 views | 2 replies

• Set File List with a variable during Multiple File Import

  I'm using JMP 18.0.1 and I noticed the new option for Multiple File Import that allows the user to provide a list files (or directories) to import. I can successfully use it in a script like so: Multiple File Import( <<Set Use File List( 1 ), <<Set File List( { "C:\file1.csv", "C:\file2.csv", "C:\file3.csv" } ), <<Set Import Mode( "CSVData" ), <<Set Stack Mode( "Stack Similar" ), ) << Import ...

  simopod

  Discussions |

  Jul 27, 2024 12:07 AM

  839 views | 1 replies

• Graph Builder-Hide Categorical Nominal Levels on Y-axis not used in specific Pages

  I have a data table that has a datetime column modelled as numeric-continuous.  I have various Serial Numbers ("SN", Categorical-Nominal) in another column, along with another Categorical-Nominal column, we can call "Y".  I want to see when certain "Y" events occur, so I put the Categorical Nominal Variable on the Y-axis and datetime on the X-axis.  For the purposes of this analysis, I choose to s...

  ashwint27

  Discussions |

  Jul 26, 2024 11:54 PM

  1068 views | 2 replies

• Refresh Col List Box

  See the script below.  This is intended to be used in a dialog window.  What this script does is set the Col List Box() min items to be either 0 or 1.  When doing this, the watermark inside the column list box should change from optional to required.  It will do this, but only after I move the mouse over the column list box (see screen video). Is there a way to make that refresh/update without hav...

  MathStatChem

  Discussions |

  Jul 26, 2024 11:36 AM

  731 views | 1 replies

• Close Invisible Tabulate Window

  I am using Tabulate to summarize some data in a script and then saving the result to a table. I use the "invisible" property (command or whatever it is) so I don't see the intermediate Tabulate window. However, I end up with a bunch of invisible Tabulate windows that accumulate as I run through the script. See image below...   I tried dtab << Close but it doesn't work. Can someone tell me how to c...

  scott1588

  Discussions |

  Jul 26, 2024 7:46 AM

  1143 views | 2 replies