Welcome to the JMP User Community!

Latest Discussions

• How do I Shorten the Fit line?

  Hello,When I fit my data using the fit line tool it send the line till the end of the graph. I was wondering if there was any way to define how long the trend line should be, such that it only spans the region I want to show. Is there also a way to get the fit line to appear within the legend?  Thanks!

  SI-2000

  Discussions |

  Jun 3, 2021 9:44 AM

  1146 views | 3 replies

• 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

  1629 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

  1073 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

  1417 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

  2758 views | 3 replies