Welcome to the JMP User Community!

Latest Discussions

• Retrieving data formatted as a string from Python

  Hello, I have a simple script that sends a variable to Python to run an SQL query ( going through JMP directly somehow is very slow, python is fine). Anyway, the query runs fine but I can't figure out how to make use of the data generated by Python and format it into a JMP table. Any suggestions would be greatly appreciated. I've created a move script which generates the string exactly as produced...

  Sburel

  Discussions |

  Aug 30, 2022 7:34 PM

  1482 views | 2 replies

• Open Excel within a button box - Strange behavior

  Hi.  I'm noticing that if I try to open an excel file using a script, the Excel Import Wizard appears if the Open command originates from a buttonbox, but it does not appear if the Open command is in the top-level of the script.  For the record, I do not want the wizard to appear in this case.  Is anyone familiar with this behavior, and if so, can I fix it? For example, I have a script where the u...

  nikles

  Discussions |

  Aug 30, 2022 4:21 PM

  3259 views | 5 replies

• Count number of occurrences of a character in a string

  Hi,I am trying to count the number of occurrences of a character in a string. How do I achieve that using JSL?For eg:Number of occurrences of letter 'A' in the below stringsAPPLE -> 1PEARS -> 1BANANA -> 2 

  psundar6

  Discussions |

  Aug 30, 2022 1:44 PM

  1883 views | 1 replies

• How to reorder columns in Col List Box by Drag&Dropping just like in any built-in platform

  I've written my own platform that runs some analysis.I cast columns into roles just like in any other platform (or it looks that way at least).I noticed, that in my custom platform in Col List Box I cannot drag and drop columns to re-order, while in any built-in platform I can do that.Do they use some other control? Or is there some optional parameter for Col List Box that allows re-ordering?  

  miguello

  Discussions |

  Aug 30, 2022 11:58 AM

  923 views | 1 replies

• Colors of bivariate fit

  Hi,  I plot a bivariate fit and fit a linear line for each "run". The colors on the row legend match the colors of the linear fit lines (see pic 1)When I apply a local data filter and change the "Date" and therefore the "Run" may change, the colors on the row legend do now match with the colors of the linear fit lines. See pic 2, the Run 14 is red dots but the linear fit line is green. Is there an...

  B1234

  Discussions |

  Aug 30, 2022 8:05 AM

  2266 views | 4 replies