Welcome to the JMP User Community!

Latest Discussions

• How to line up each field?

  I have txt file. I would like to import to JMP to analysis. But some columns are not line up. How do I line up them?The delimited should be space, spaces and comma. But ", " will treat space as text. How do I overcome this problem?dtTlog = Open( D, Import Settings( End Of Line( CRLF, CR, LF ), End Of Field( Spaces, Space, CSV( 1 ), Comma ), Strip Quotes( 1 ), Use Apostrophe as Quotation ...

  Victor3

  Discussions |

  Jul 29, 2024 2:19 AM

  1454 views | 6 replies

• 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

  532 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

  452 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

  639 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

  457 views | 1 replies