Welcome to the JMP User Community!

Latest Discussions

• With multiple Data Table how do i link it such that each time i rerun it will choose the correct one.

  Hi all, I have a JMP script which generates a Journal with different plots using different data tables. Using the journal how can i rerun the plot without having to choose which data table to use.  For( i = 1, i <= N Items( colPlotType ), i++, /* SET THE CURRENT DATA TABLE TO THE APPROPRIATE REPORT TYPE */ If( /* IF REPORT TYPE IS PD*/ colReportType[i] == "PD", /* THEN */ If( Is Empt...

  Dyan

  Discussions |

  May 23, 2023 3:25 PM

  994 views | 1 replies

• Formatting is not accepted (col << Format( "Fixed Dec", 10, 2 )) and still getting 3 decimal point as the output. What am I doing wrong?

  Hello dear community, I am assigning the two decimal point format to a column but when i extract this value it is still showing 3 decimal points. I would appricate your input. Here is an example:// Open Data Table: Antibiotic MICs.jmp // → Data Table( "Antibiotic MICs" ) Open( "$SAMPLE_DATA/Antibiotic MICs.jmp" ); // Standardize column attributes-The main idea is the format= Fixed Dec, 10, 2-show...

  Aziza

  Discussions |

  May 19, 2023 12:39 AM

  1856 views | 3 replies

• Get values in the list from SQL query

  Hi, Is there way I could insert the column values in the list than jmp table?
  
  I 'm trying to write a JSL code to query data from database and I want to store the values from the SQL table into a variable list (not in the JMP table).
  For example, save the WorkCenter sql table values in the list= {};
  Any suggestions?
  
  Thanks,Jackie

  Jackie_

  Discussions |

  May 19, 2023 12:04 AM

  2652 views | 4 replies

• How to read and update Effect content in the fit model with JSL?

  Hi folks,
  
  I have several models in the JMP data table, I know how to read the scripts with JSL. Is there any easy way to extract the effect from this script, make changes and replace with a new effect? If Block is inside the model effect, I need to change it into a random effect to run model again with REML. Thank you so much for your help.

  lazzybug

  Discussions |

  May 15, 2023 12:50 PM

  1075 views | 1 replies

• JSL to Python Scripting

  I am very new to both Python and JSL and am trying to run a script I wrote in Python through the JSL-Python connection. I would like to:1. Select a .txt file from my desktop 2. Send that file to Python3. Execute the tidying procedure I've written  4. Return a JMP table  This is currently what my code looks like. Thanks so much for any advice!    

  efulton2

  Discussions |

  May 15, 2023 11:59 AM

  2312 views | 2 replies