Welcome to the JMP User Community!

Latest Discussions

• Rename column name based on value from xth rows

  Hi All,I am trying to use jsl to rename the column name of a datatable using rows value from row that met predefined criteria.My script is as followed:  dt = Open();
    Current Data Table() << set name( "ABC" );
    dt = Data Table( "ABC" );
    lastcol = N Col( dt );
    header=dt<<Get Rows Where (:(2)=="Colour"); // this is the criteria, i wanted to identify the row where the value in column2 is "Colour"
    ...

  novicepg

  Discussions |

  Feb 17, 2013 4:46 PM

  12030 views | 2 replies

• Different highlighting in JMP 10 when selecting points on graph with line

  In JMP 8 and 9, if you created a graph with graph builder with points and connecting lines, you could select individual points on the graph.In JMP 10, if you create a graph with points and connecting lines, when you select a point it selects the entire line (and all of the rows in the data table).  If you draw a graph using only points (no connecting line), then you can select individual points.Is...

  pmroz

  Discussions |

  Feb 9, 2013 4:00 PM

  3971 views | 2 replies

• How to change many column properties at once?

  Anyone know how to change many column properties at once (e.g. have imported data and JMP assumes all character and I need to change all to contiesinuous numeric) ?  "Column Info>Data Type> Modeling Type>OK" for several dozen is TOO much!Thx!

  steven_reagan

  Discussions |

  Feb 7, 2013 8:13 AM

  5488 views | 2 replies

• Username/Password required to open website with JSL

  I'm trying to access a CSV served by one of our web APIs, but it's behind an authentication wall.  When I use the traditional Open() statement, I'm told that the resource was not found, and passing the parameters using the https://user:password@website.compassword@website.com results in the same error.I AM able to open the file with the Web Browser Box() function, which authenticates through a Win...

  afterword

  Discussions |

  Feb 6, 2013 12:16 PM

  3825 views | 1 replies

• Select Where() not working

  I spent a lot of time trying to create a simple "Select Where()" statement in JMP, and it was not working.Here's the line of code I was trying to use: dtData << select where(yParamList <= minLimList);yParamList is a valid columnminLimList is a valid numberAfter reading some of these forums, I found someone suggesting to put it all in a string and then parse it out, so i changed the above code to t...

  mikedriscoll

  Discussions |

  Jan 31, 2013 4:43 PM

  8689 views | 2 replies