Welcome to the JMP User Community!

Latest Discussions

• JMP adding characters to string?

  Hi all,I had some code that extracted some numbers into variables, and then I put them together in a string.xlocation = dt1:Die_X[x];           ylocation = dt1:Die_Y[x];site = dt1:Site[x];deviceName = "x="||char(xlocation)||" y="||char(ylocation)||" Site"||char(site);It would output something like this:  x= 8 y=2 Site2But now it outputs this:  x=[8] y=[2] Site[2]I am not sure what I changed.  The ...

  natalie_

  Discussions |

  Mar 15, 2016 8:46 AM

  10064 views | 3 replies

• Naming subsets in JSL

  Hi!I have a large dt, and want do make subsets from a column. I've managed to do it, but the subsets have all the columns locked. How I can unlock them in the code?Also, how can I specify it's names, so I can work with those later?dt2 << (Subset(                   By( :Filial ),                           Selected Rows( 0 ),                           columns( :Cod. Cliente DPK,                     ...

  theo_beluzzi

  Discussions |

  Mar 15, 2016 6:41 AM

  9973 views | 2 replies

• How to automatically save run chart image in script?

  Hello All,I created this script to open a text file, filter the data, and then generate a run chart. Is there away I can also have the script automatically save the run chart as a .gif/.jpeg file in a chosen directory?The exact script can be seen below. Thank you for the help!  Open( "R:\Operations\Engineering\FTP DATA\FT_LPC_Results.txt", Date = Numeric, Time = Numeric, Lot # = Character, Part # ...

  dustin_lewis_ri

  Discussions |

  Mar 11, 2016 1:28 PM

  20364 views | 7 replies

• Missing value codes not working in functions?

  Hi All,I was wondering what is the best practice for finding the listwise missing observations in a set.I was using the “Is Missing” function in order to indicate missing observations. Yet the result was somewhat disappointing since it does not take into account missing value codes. Apparently, the missing value codes only works with platforms. For example:dt = Open( "$SAMPLE_DATA/Big Class.jmp" )...

  ron_horne

  Discussions |

  Mar 11, 2016 10:23 AM

  10376 views | 4 replies

• 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

  9611 views | 1 replies