Welcome to the JMP User Community!

Latest Discussions

• How to look up a value in a cell.

  Can I assign a value to a variable using a database, a column, and a row?My script, at present, opens a timestamped database of information for my system.  I add a column that declares the last row when a certain valve was open.  I can use Col Max to find the latest overall point when that occurs. I'd like to assign a variable for the Timestamp when that occurs.  Of course I could just make a new ...

  zechariah

  Discussions |

  Oct 7, 2013 7:19 PM

  5319 views | 1 replies

• remove part of a string (contingent upon number of periods within that string)?

  I have a column with strings of varying length.  All strings have 1 semicolon separating the first and last part of the string.some strings with no 'periods':_______________;______some strings with 1 period______.______;_______some strings with 2 periods___._______._____;_________I want to create a new column and populate it with the string of interest with the following conditions:IF a string con...

  jmpbeginner

  Discussions |

  Oct 7, 2013 10:43 AM

  10045 views | 3 replies

• Count up

  Hello!I need to create a run chart with phases. Each phase is defined by a change in a certain column.COL1                                        COL2     COL3T=1, R02, P=2, T2=3, R03=5     0               5T=1, R02, P=2, T2=3, R03=5     0               5T=1, R02, P=2, T2=3, R03=5     0               5T=1, R02, P=2, T2=3, R03=5     0               5T=1, R02, P=2, T2=3, R03=5     0               5T...

  peder

  Discussions |

  Oct 5, 2013 6:28 AM

  10003 views | 3 replies

• Mapping a Network Drive with a DLL

  Hello,I'd like to be able to map (and then unmap) to a specific network drive as part of a JSL file using a DLL. Through talking to some internal IT people they've pointed me to mpr.dll and the WNetAddConnection2 and WNetCancelConnection2 functions. However, I'm not an expert programmer and so even though I've looked at the examples in the Scripting Guide and the examples on this discussion board ...

  drc_lewis

  Discussions |

  Oct 2, 2013 6:15 AM

  9912 views | 3 replies

• using JSL to rename 'Oneway( )' output filename?

  I have been using 'output table name( )' to rename all of my summary tables, but this does not seem to work for with oneway( ):
  example:dt_Oracle<<Oneway(  Y( :Average ),  X( :TOOL_ID ),  Each Pair( 1 ),  Box Plots( 1 ),  Comparison Circles( 1 ),  X Axis Proportional( 0 ),  Grand Mean( 0 ),  By( :Rec ),  output table name("OneWay_"||tool||"_Average by Tool_ID_"||startDate||"_to_"||endDate||"_origin...

  jmpbeginner

  Discussions |

  Sep 30, 2013 12:13 PM

  8583 views | 2 replies