Welcome to the JMP User Community!

Latest Discussions

• Col Formula Month()

  I have a data table where I have multiple date with times. I'm trying to change all the dates into just the month and maybe even a month-year format.I know I've done this before by selecting the column going to formula and putting together Month(DateandTime) than I would use recode to change numbers into Jan. - Dec. When I'm trying today, the Month() formula is changing my date to just dots. I've ...

  Herrera5238

  Discussions |

  Feb 25, 2020 6:52 AM

  15017 views | 13 replies

• help with tables

   dt = current data table(); dt << subset(by(:p20000), All Rows, All Columns); //When I subset dt by :p20000, it outputs atmost 3 data tables ‘p20000=1000’, ‘p20000=1001’, ‘p20000=1002’. //What I do next is to check if such dt exists exist= Try(Data Table("P20000=1002");tableExist = 1,tableExist = 0); );

//if tab_1002,
tab_1002=expr(insery my long script here);
//if tab_1001,
tab_1001=expr(insert s...

  viskovicz00012

  Discussions |

  Feb 25, 2020 3:10 AM

  1292 views | 1 replies

• JSON Unterminated String Error when Submitting HTTP Request

  Hello, I have an online application that I can request data extractions from by submitting an HTTP request with the appropriate JSON fields. One field (field2) within my JSON payload is a list type and can contain one or more items. The issue that I am facing is that my JMP script functions only if this list has a single item and not if it has two or more. The error that I receive is:"error":"com....

  caseofmondays

  Discussions |

  Feb 24, 2020 1:48 PM

  3561 views | 1 replies

• Bootstrap forest tuning parameters, number of splits, and prediction formula

  Dear JMP & Community,   (W10 Enterprise, JMP Pro 15.0.0)   I'm curious as to know which of the tuning parameters for bootstrap forest modeling impact the number of splits on each factor. I'm familiar with how to use a tuning table and so forth to optimize the fit for maximizing the fit, e.g. R^2 for the validation set. Of the six parameters highlighted below, which one(s) can affect the Number of ...

  SDF1

  Discussions |

  Feb 24, 2020 1:03 PM

  2826 views | 2 replies

• Table Column Headers - possible to make vertical?

  Hi, Is there any way to change a table report's column headers from horizontal to vertical alignment?  (like Excel can)
  For example, working with a dt with a <<Get As Report or working with a Tablebox() with associated String Col Box() and Number Col Box() commands.  If possible, this would save a ton of space for viewing purposes on larger tables. (i.e. saving the table report as a PNG, etc)
  Else, ...

  djhanson

  Discussions |

  Feb 24, 2020 8:48 AM

  2763 views | 2 replies