Welcome to the JMP User Community!

Latest Discussions

• IMPORT EXCEL FILES VIA JSL - COLUMN FORMAT

  Hi all i am using JSL of JMP 11.I want to import and excel file.Is there a way to force JMP/JSL to import ALL COLUMNS as TEXT (CHARACTER) ?My columns have empty cells and text and number. The script I wrote in JSL automatically read them as number, therefore putting missing values in my text cells.I want to import them as text.here the piece of code.dt = Open("mydata.xlsx", Worksheets( {"Sheet1"} ...

  angela_manginel

  Discussions |

  Mar 11, 2016 8:08 AM

  9566 views | 1 replies

• Iterating through mulitple outline boxes in a report via jsl

  Hi all,I've searched through Scripting Guide and the Scripting Index, but can't find a way to do what I want to do.Here's the task:I am writing a script that runs many other pre-existing scripts one-at-a-time. Needed aspects of each pre-existing script's report are taken and copied into a "Full Report" master window.Due to trust concerns, I am not allowed to alter any pre-existing scriptsIf I only...

  tomlight

  Discussions |

  Mar 11, 2016 6:31 AM

  4430 views | 1 replies

• How to save graph automatically from JMP to powerpoint using jsl

  I had given a task to create an automation system which is to automatically save graph from JMP to power point. I already follow several tutorial from this page but it's did not work. I hope someone can help me or give suggestion. thank you.This is script that i working on, the source of this script also from this page./!names default to here(1);dt = open("$Line Delta - Shared\KLM 5, 6 Eff and IV ...

  sismyra_93030

  Discussions |

  Mar 10, 2016 7:29 PM

  15271 views | 2 replies

• Calculating Standard Deviation

  Hi all.I have a question about JMP and calculating standard deviation.
  From my understanding about statistics, there are different formulas to calculate stand deviation for different types of distribution (normal or gamma for example).  When I am use JMP to calculate standard deviation, does it always assume that my data has a normal distribution?

  natalie_

  Discussions |

  Mar 9, 2016 1:42 PM

  25800 views | 2 replies

• error: "Expression does not fit available column types"

  Hi everyone,In the following code I get the error: "Expression does not fit available column types" , and it happens during the formula evaluation..I'm just trying to reference the same table as I am adding a new column to, such as subtracting two columns within the table called "dt" that I am adding a new column to... Can't figure out why it's not working.dt = myTable();cols = dt << GetColumnName...

  eveyja

  Discussions |

  Mar 9, 2016 10:38 AM

  8097 views | 5 replies