Welcome to the JMP User Community!

Latest Discussions

• How to join\Update Multiple data tables using same Match ID

  hi,i am trying to join multiple data tables  using same match id.update_table= Data Table( PS1(ma) " ) << Update(  With( Data Table( "PS2(ua) ")),  With( Data Table( "PS3(ua) ")),With( Data Table( "PS4(ua) ")),  Match Columns( :match_col = :match_col ),  output table name("FINal"));above code only updates\joins very first table and ignores rest.Is there a way to join\update multiple tables at same...

  jump

  Discussions |

  Oct 7, 2014 3:16 PM

  12041 views | 3 replies

• Close Local Data Filter Outline Box

  Hello all,I'm trying to create a graph with a local data filter pre-added to it.  To save a bit of time I'm also ordering the filter elements by count.  I want the graph to look like this initially.  As you can see the local data filter is there, and it's outline box is closed.When you open the local data filter this is what you should see.  Notice that the items are ordered by countWhen I save th...

  pmroz

  Discussions |

  Oct 7, 2014 9:52 AM

  8682 views | 2 replies

• Syntax: How do I create an index column by ID

  Hello JMP Community,   I am trying to create a column that indexes rows by an ID column. In other scripting language, this is accomplished with the following lines. By ID: gen IDIndex = _n By ID: gen IDCount = _N   I can do the following, but I index and count the whole table New Column( "IDIndex", formula( Row() ) ); New Column( "IDCount", formula( N Row() ) ); Advice on this would be great! Very...

  mpg

  Discussions |

  Oct 7, 2014 8:59 AM

  29507 views | 5 replies

• how to make a subset of a table and append data from loop

  Hi,   I have a set of data, (see attached). i want to check every row on a column (against a certain criteria) and then isolate rows that do not meet that criteria and subset them into a new data table. i want to be able to repeat this for multiple columns (where each has its own criteria) and continue adding to this subset table that i originally created. i'm having some trouble with this and was...

  bk

  Discussions |

  Oct 3, 2014 7:35 AM

  6365 views | 2 replies

• Fit Model: Square Transformation vs 2nd Order Polynomial

  I am using the Fit Model platform in JMP to create a simple standard least squares fit with one model effect.  I noticed that using the square transformation on the effect gives a different fit than using the 2nd order polynomial of that effect (after removing the first order term to leave only the 2nd order term).  JMP gives a warning about leaving the 1st order term out of the model, but I conti...

  kcros

  Discussions |

  Sep 27, 2014 11:49 AM

  10507 views | 3 replies