Welcome to the JMP User Community!

Latest Discussions

• SQL query from 2 or more databases

  I have been creating some queries to an SQL database to extract some of the information from a master table and some other linked tables in a database.Now I want to be able to create a query that links tables located in two separate databases (both located in the same server) but I do not know if this is possible.When you create a query, the connection seems to be linked to a specific database in ...

  morenopelaez_p

  Discussions |

  Feb 16, 2016 1:20 AM

  7246 views | 4 replies

• Bug in graph builder with grid lines and right side axes?

  I think I found a bug (in JMP 12.1). Please try this script:dt = Open("$SAMPLE_DATA/Big Class.jmp");gb = dt << Graph Builder(    Size( 570, 667 ),    Show Control Panel( 0 ),    Variables(        X( :age ),        Y( :height ),        Y( :weight, Position( 1 ), Side( "Right" ) ),        Y( :age ),        Y( :name )    ),    Elements(        Position( 1, 1 ),        Points( X, Y( 1 ), Legend( 5 ) )...

  cis_pete

  Discussions |

  Feb 12, 2016 9:32 AM

  5218 views | 1 replies

• save factor scores using script

  I am wondering anyone knows how to save factor scores in a table using script. When I study “factor analysis”, I am unable to include the factor scores in the report except saving  them in a table by clicking “save rotated components.” I'm obtaining the factors using Analysis->Consumer Research -> Factor Analysis using a factoring  method of Principal Components and Prior Commuality and a rotation...

  likunz0

  Discussions |

  Feb 12, 2016 7:48 AM

  5684 views | 2 replies

• Select a range of rows with variables

  Hi everyone,Is it possible to select a range of rows with variables?This is what I have, but it found the maximum over the entire range: vlower = lowerVoltage << get;   vupper = upperVoltage << get;   row1 = (vlower/10)+1;  row2=(vupper/10)+1;select_rows = row1::row2(dt2);           select_values = dt2:Idoff(select_rows);id = maximum(select_values);
  
  

  natalie_

  Discussions |

  Feb 12, 2016 6:50 AM

  4500 views | 2 replies

• Control Chart Value Ordering

  Is there a way, when making a control chart (not using control chart builder) to get the “Sample Label” sorted according to the Value Ordering assigned to that column? Every time I try it, even if there is a value order assigned to the column, the control chart will display the data in the order it appears in the table, which is frustrating if you want to use the manual control chart rather than c...

  kschnarrs

  Discussions |

  Feb 10, 2016 7:27 AM

  7566 views | 5 replies