Welcome to the JMP User Community!

Latest Discussions

• Lasso Tool in the modal window

  Hi, Is there a way to call Lasso in the modal window?  JMP documentation says to press L, but it doesn't work in the modal window. Any suggestion? Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); New window("",modal, gbp = Graph Builder( Variables( X( :height ), Y( :weight ) ), Elements( Points( X, Y ), Smoother( X, Y ) ) ); )Thanks,

  Jackie_

  Discussions |

  Apr 22, 2024 10:44 PM

  1161 views | 2 replies

• A function to add columns with names that has a prefix

    Hi community,   I want to write a function to add columns that have names that has a given prefix, and give values to the columns based on given conditions. This is the script that I have, but it errors out "Unresolved Column". I double checked everything and don't know where went wrong...   Much appreciated for the help!   add_extra_columns = Function({dt, prefix}, {Default Local}, dt << New...

  DivisiveEagle45

  Discussions |

  Apr 22, 2024 10:31 PM

  1744 views | 5 replies

• How to group using last 2 characters and subset the latest data?

  Hi all, Is it possible to make a column for groupings using the last two characters from another column? For example, I have this table:FYWGroupingsFY24W381FY24W381FY24W392FY24W392FY24W392FY24W403FY24W414FY24W414 Is it also possible to subset the first 2 latest date according to the grouping? In this example, FY24W40 and FY24W41 will be selected then subset since they are the "latest" data. TIA 

  UserID16644

  Discussions |

  Apr 22, 2024 9:26 PM

  1186 views | 2 replies

• How to remove a user-defined text from all columns or all column names?

  For example, I have a table: 1. All column names contain "CHA/", how could I remove it quickly and leave it like "Temp""Pressure" and "Flow"? In the real case, I have hundreds of columns containing "CHA/".2. How could I make the first row as the column names? 3. Is there any way to remove "CHA/" from all the cells in the table?  Thank you!

  Fruit325

  Discussions |

  Apr 22, 2024 7:27 PM

  1769 views | 4 replies

• How does JSL extract a subset of selected rows for a column in a data table?

  It seemed like a simple question, but I didn't succeed.
  This selected line number is already selected by other scripts.Thanks! dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); r = dt << Get Selected Rows(); d3 = dt << Subset( Output Table( "tt" ), Selected Rows( r ), selected columns( 0 ) );

  lala

  Discussions |

  Apr 22, 2024 6:58 PM

  1447 views | 3 replies