Welcome to the JMP User Community!

Latest Discussions

• Refresh Excel SQL quarry before extracting data to JMP

  Hi,Just wondering if there is a way to use JMP scripting to refresh data in the Excel workbook before it is being imported to JMP table.I can't build direct query from JMP to the database because there is too many obstacles like very old and not updatable Acces database on very old tool and differences in bitnes between office and JMP, but I can extract data from the Excel whchi has build in SQL q...

  swiergi11

  Discussions |

  Dec 8, 2021 7:40 AM

  934 views | 1 replies

• How to set "characters" as "missing values"?

  My table on JMP has a column that contains both numbers and characters. The table lists down products, and this column records the minimum requirement for a specific performance test. Therefore, the cells of the columns could store one of the three:- a numerical value;- "N/A" when the test is not required to be performed on a specific product (entry);- two alternative numerical value (e.g. 4.5 if....

  SaraGo

  Discussions |

  Dec 8, 2021 7:37 AM

  1495 views | 1 replies

• How to calculate TF-IDF

  Dear all, I am new to using this software and am struggling to figure out how to use it to calculate the TF-IDF values for documents in my data set.  I am sure it is included in the functionality of JMP but it must be under a different name. Would anyone be able to point me in the right direction? ThanksMark

  markw

  Discussions |

  Dec 8, 2021 7:20 AM

  4972 views | 11 replies

• Font size - Graph builder, Title

  Hello,New SAS JMP user.How do I change font size on only the title in Graph builder?I have tried to change my font settings within Preferences but the font doesn't change.  KR.Alberthe

  BFVDK

  Discussions |

  Dec 8, 2021 5:42 AM

  1129 views | 1 replies

• Loop on script files

  Dear jsl scripters,   I have a script in which I use the include instruction to call a subscript for "reporting" (inserting a JMP chart into a powerpoint file):     dt = Current Data Table(); Include( strRootPathScript || str_report_Product1) );     It works fine as long as I use 1 product. My wish is to loop on a liste of products [Product1;Product2;...] and to replace the product name into the i...

  J_Bonnouvrier1

  Discussions |

  Dec 8, 2021 5:33 AM

  1982 views | 3 replies