JMP User Community

Latest Discussions

Parse a concatenated string which has comma

Hi all, I have a datatable with multiple columns, some of which I want to add together. As a part of my script, I am selecting some of the columns, storing the column names in a list and then hoping to add the selected columns using the "Sum" feature. In order to do that I need to build a string ":DATA1, :DATA2, :DATA3" and Parse it in a column. New Column( "Addition", Numeric, Continuous, Form...
noviJSL

Discussions |
Jun 9, 2020 12:11 PM

2529 views | 2 replies
How to find row and column (cell) that matches a value

I have tables that are generated and the format is different from time to time and it breaks my script. The tables are massive and so the way i handle my loops is that i import the first 100 rows and 5 columns, for speed. Then i search a particular column for a keyword to help me know where which row the real data starts. I close the file then reopen with that variable identifying the column he...
SamKing

Discussions |
Jun 9, 2020 7:11 AM

4120 views | 2 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1173 views | 0 replies
How do I stop UI from looking like it hang up while doing long for loop operation

I made I UI that lets the user choose which process, temperature and voltage to include in the computation of Cpk, the script will iterate over each combination of process, temperature and voltage. I noticed that the UI hangs up while it is doing its operation. Is there a way to avoid this? I think a function similar to DoEvents in vb6 or better, a background process worker ?
TheRealYeti

Discussions |
Jun 9, 2020 3:34 AM

3982 views | 6 replies
Load data to a google sheet using JMP

Hello everybody, I was wondering if it was possible to load data to a google sheet using JMP. I'm running a script, it generates some numbers, and I would like those numbers to end up in a google sheet. Any ideas on how to do this? Cheers, Eduardo
Eduardo

Discussions |
Jun 9, 2020 2:02 AM

3733 views | 2 replies

Previous
Next

Latest Discussions

How to find row and column (cell) that matches a value

I have tables that are generated and the format is different from time to time and it breaks my script. The tables are massive and so the way i handle my loops is that i import the first 100 rows and 5 columns, for speed. Then i search a particular column for a keyword to help me know where which row the real data starts. I close the file then reopen with that variable identifying the column he...
SamKing

Discussions |
Jun 9, 2020 7:11 AM

4120 views | 2 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1173 views | 0 replies
Load data to a google sheet using JMP

Hello everybody, I was wondering if it was possible to load data to a google sheet using JMP. I'm running a script, it generates some numbers, and I would like those numbers to end up in a google sheet. Any ideas on how to do this? Cheers, Eduardo
Eduardo

Discussions |
Jun 9, 2020 2:02 AM

3733 views | 2 replies
can JMP open google sheet?

any way JMP can open or import google sheet?
wma1125

Discussions |
Jun 9, 2020 2:01 AM

10810 views | 7 replies
Fit spline methodology/calculation?

Hi All, Currently i manually analyse the data and generate splines (all done manually). I am trying to write a python code which can eventually run on the company server.python's cubicspline function does not match the spline i normally generate in jmp (Analyze --> Fit Y vs X--> Flexible --> Fit spline --> Other --> Specify smoothness =0.1 check Standardize x (red)When i am generating in Python (c...
deveshchugh

Discussions |
Jun 8, 2020 3:58 AM

4492 views | 3 replies

Previous
Next

Latest Discussions

Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1173 views | 0 replies
How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4434 views | 0 replies
How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2038 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

1885 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1560 views | 0 replies