Welcome to the JMP User Community!

Latest Discussions

• Concatenate columns with empty cells

  Hi all,I have a dataset with different columns that have some empty random cells (like the example in the table below). I would like to concatenate the values of the different columns and use the "_" to separate the content of the cells only if the content of the cells is different from empty value (as in column "concat" below). Does anyone have a suggestion on a how to to this operation in a smar...

  JMP_fan

  Discussions |

  Jun 3, 2021 9:02 AM

  2247 views | 3 replies

• Using a List to Filter in Custom Query Builder - Question

  Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom ...

  Benjamin_S

  Discussions |

  Jun 3, 2021 7:59 AM

  1377 views | 0 replies

• JMP TIP: delete search / replace history

  I frequently use the Search/Find/Replace (Edit > Search > Find) in data tables and scripts and even reports and journals, it is very useful.  But one feature is that this tool retains the history of the terms you have used for search and/or replace.  You will see them as a drop down in the dialog as shown below There are times, however, where you don't want to retain the search history and/or don...

  MathStatChem

  Discussions |

  Jun 3, 2021 3:23 AM

  1953 views | 1 replies

• Add Rows question

  Hello, New JSL scripter here. Trying to get 5 new rows added after every existing row, 25 rows in the data table. No issues while debugging, i changes from 25 to 1 in increments of 1 as expected, but no new rows are added to my data table at any point during/after the For loop. Not sure what I'm doing wrong, any help would be appreciated!dt=current data table(); For(i=N Rows(dt),i>=1, i--, dt <<...

  dlemieu1

  Discussions |

  Jun 2, 2021 3:38 PM

  3649 views | 3 replies

• Update from Database on a Timed Frequency

  Hello,I currently have a script that requires user input to define variables that are used to query a database and generate control charts. To eliminate the need for an operator to provide these inputs again to generate the control charts whenever new data is in the database, I would like to automatically update the control chart on a timed frequency. For example: 1. User provides input.2. Initial...

  Austin

  Discussions |

  Jun 2, 2021 9:23 AM

  1171 views | 1 replies