Welcome to the JMP User Community!

Latest Discussions

• Heatmap Labels Too Big

  I have a custom heatmap made of squares in a grid. When displayed on a smaller screen the labels from the labelled columns spill over and don't fit into their square. They would fit in the square if they were not all in a horizontal line and instead were formatted to stack vertically. Is there any way to script JMP to display the labels not in one line and instead fit into the box.

  Jemster

  Discussions |

  Jul 28, 2022 8:49 AM

  1249 views | 1 replies

• How do I manipulate column formulae in data tables by scripting?

  Hi,  I'm trying to add a formula to convert values in a selected column through scripting without having to add any new columns in the data table, is there a way to edit formulas for a column by scripting? For example I'm trying to set the height column in this data table to be halved when I run the script:Names Default To Here( 1 ); Open( "$SAMPLE_DATA/Big Class.jmp" ); Current Data Table() << Ge...

  PowerOx327

  Discussions |

  Jul 28, 2022 6:29 AM

  1465 views | 2 replies

• Append calendar box

  Hi, I am trying to create a UI to select dates. I have added a button box which will append calendar box to the panel box but every time I click, it will keep adding elements to the panel box. I want to hide the calendar box on second click. Is there a way to achieve this? Here's my code:sd=Today(); ed=Today(); New Window( "Query Date", <<Modal, HListBox( Panel1= PanelBox( "From Time"), Bu...

  Jackie_

  Discussions |

  Jul 28, 2022 6:00 AM

  1509 views | 2 replies

• How do I use the include function to run a separate script which uses an open data table?

  Hi all, I've created a script which pulls from SQL and creates a data table as so:   Names Default To Here( 1 ); dtFROMSQL = Execute SQL( databaseConnectionHandle, "SELECT HEIGHT, WEIGHT FROM Bigclass", "NewTable" );
Include(filepathforsecondscript.jsl);And then I have another script in my personal folder which adds a column to the data table:Current Data Table( dtFROMSQL ); dt << New Column( "X", ...

  PowerOx327

  Discussions |

  Jul 28, 2022 5:45 AM

  2119 views | 3 replies

• How to add repeating character values to column?

  Hi, 
  
  I'm looking to create a column and populate it with a list of character and numeric values - [ Min, Max, 0.5, 0.6,.....,1], and this list repeated 50 times. I usually copy paste these into a column (as shown below), but I'm wondering if there's a way do it using JSL ( using JMP14).  Thanks.

  D_T_M

  Discussions |

  Jul 28, 2022 4:00 AM

  1207 views | 1 replies