Welcome to the JMP User Community!

Latest Discussions

• Join two tables with variable names

  Hi,   I like to join two tables with variable names. Here is the script.   Eval( Parse( "s3 << Join( With( rds), Merge Same Name Columns, By Matching Columns( " || name3 || ", " || name4 || " ), Drop multiples( 0, 0 ), Include Nonmatches( 1, 1 ), Preserve main table order( 1 ) );"   ) );   I get an error " Name Unresolved: Red LED Hue x 64{1} in access or evaluation of "Red LED Hue 64/*###*/...

  AT

  Discussions |

  Mar 27, 2018 4:38 PM

  5275 views | 6 replies

• Creating a list of Column References

  I am trying to make a list of column references to later use in making a stacked data table.When I make the list inside a function it works perfectly fine.  However, when I try the same inside a class method it does not work yielding the error message: "No value to Op Assign"(1, 2). make_col_list = Function({dt,start,end}, Local({lst,col_list}, Try( Current Data Table(dt); col_list = {}; ...

  awsmagala

  Discussions |

  Mar 27, 2018 11:02 AM

  2586 views | 1 replies

• How do I perform row operations in looping?

  Hello,I have a table like below.A B C ..n columns1 2 37 6 43 7 9..m rowsI want to write a script such that for every column " Value of nth row= Value of nth row -Value of 1st row" and in the end reset the first row to 0. So in the end my table should look likeA B C0 0 0..6 4 12 5 6..Could someone help me with a script for such an operation? Thanks 

  PG

  Discussions |

  Mar 27, 2018 12:27 AM

  5765 views | 2 replies

• Solution to sorting bar charts single by category count

   I banged my head against the wall figuring out how to sort a simple bar chart of a category (which graph builder can automatically count and display the proper bar heights for, but gives no sorting abillity by that count...). All the articles out there talk about sorting by some other continuous variable dropped into the merge zone of the graph builder http://www.jmp.com/support/notes/42/770.html...

  rossjason

  Discussions |

  Mar 26, 2018 2:27 PM

  4808 views | 3 replies

• Finding values in a list

  If I have a list:List = {Henry(1,2), Robert(3,4), John( . ,6), Kai(13, . ) };But the position of names is always different for different tables,List = {Henry(1,2), Robert(3,4),  Kai(13, . ), John( . ,6) };and sometimes certain names are missing too.List = {Henry(1,2), Robert(3,4) };I know we can use Contains(List, List[1]) but that way, we consider the position of values in a list. I want to know ...

  Aam_jmp

  Discussions |

  Mar 26, 2018 12:00 PM

  9874 views | 4 replies