Welcome to the JMP User Community!

Latest Discussions

• Iteratively create columns containing formulae.

  I would like to iterate through the columns that have spec limits and perform analyses against those. 
 New Column("WM Minus Target", Numeric, "Continuous", Format("Best", 10), Formula(:WN - (:WN << get property("Spec Limits"))["Target"]), Set Selected);The script located here is close to what I want. Solved: When a spec is on, how do I write a script when I want to write a fail name? - JMP User C...

  SpannerHead

  Discussions |

  May 31, 2024 3:58 AM

  1541 views | 7 replies

• JMP18: python: conversion from pandas to dataTable skips columns with missing values

  import jmp, numpy as np, pandas as pd import jmputils def p2j(df): dt2 = jmp.DataTable('dt2', df.shape[0]) # get the column names from the data frame names = list(df.columns) # loop across the columns of the data frame for j in range( df.shape[1]): # check if the coulumn data type is string or numeric if is_string_dtype(df[names[j] ]): dt2.new_column(names[j], jmp.DataType.Character) ...

  minion

  Discussions |

  May 30, 2024 6:18 PM

  1533 views | 3 replies

• Retrieving limits when running chart script

  Is there a way to script the retrieval of limits from a separate table each time the chart script is run? IR chart creation allows "get limits" functionality but the limits are saved into the script and will not retrieve revised limits from the same source table during subsequent chart retrieval. JMP 17Existing code :"NAME, %"n,
  Individual Measurement( Avg( 0.013 ), LCL( -0.039 ), UCL( 0.066 ) ). 

  smw1985

  Discussions |

  May 30, 2024 4:37 PM

  651 views | 1 replies

• Update column with formula

  Hi all,I have two data table (dt1 & dt2). I need to add dt2's column (Col1) to dt1 with a formula in it. But when I update the table, the values from Col1 are empty. Seems to be a problem in the formula. Please help current data table (dt1); dt1 << Update( With( dt2), Match Columns( :KeySample= :KeySample), Add Columns from Update table ( :Col1) ); dt1:Remarks << Formula ( If( :Col1== "Out of...

  UserID16644

  Discussions |

  May 30, 2024 11:53 AM

  1862 views | 5 replies

• JMP 17

  Hello,I recently upgraded to JMP 17, and I'm encountering a strange issue. When I open the data table window on the full screen, the script JSL window also opens on the full screen. Additionally, when I minimize the script JSL window, the data table window is also minimized. How can I fix this and keep the windows at different sizes?

  Dennisbur

  Discussions |

  May 30, 2024 8:59 AM

  955 views | 3 replies