JMP User Community

Latest Discussions

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

2019 views | 0 replies
Sort Columns in Descending Order and use 4 largest for calculation

I have a data table and I need to get the first 4 largest values from a range of columns, labeled "Nozzle #". These column values vary by variable, or column labeled "Test #". I then need to apply these values and in a new column calculate area of a circle per test #. Since I have a larger data table, I would like to either group the columns using the For, If, and Contains logic or is there a more...
morenrx1

Discussions |
Jan 16, 2020 9:16 PM

4335 views | 7 replies
calculating sum of lag x rows

I am trying to create a column that calculates the sum of the lag 24 rows. In this instance I have a column "Precip" that contains hourly precipitation totals. There is a second column "precipitation station" denoting from which location each value was recorded. I have sorted the columns based on "DateTime" and the "Precipitation Station". I am looking for an efficient way to sum the previous 24 ...
RVhydrA

Discussions |
Jan 16, 2020 11:15 AM

3794 views | 4 replies
Inaccessible Files on OneDrive

I appreciate that this is not really a JMP problem but an IT issue of ours that I need to talk to them about, but I'll float it here anyway in case anyone has any suggestions. The local C: drives on a recently-installed new batch of laptops here appear to been replaced by links to a centrally-located OneDrive account - and as soon as any files saved to the $DOCUMENTS directory (or any subdirectory...
DMR

Discussions |
Jan 16, 2020 9:07 AM

5935 views | 6 replies
Formulas similar to Frequently used excel formulas in JMP

How to enter a formula similar to sumif, count if and vlookup in jmp
Sivaguru

Discussions |
Jan 16, 2020 6:41 AM

4164 views | 1 replies

Previous
Next

Latest Discussions

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

2019 views | 0 replies
Sort Columns in Descending Order and use 4 largest for calculation

I have a data table and I need to get the first 4 largest values from a range of columns, labeled "Nozzle #". These column values vary by variable, or column labeled "Test #". I then need to apply these values and in a new column calculate area of a circle per test #. Since I have a larger data table, I would like to either group the columns using the For, If, and Contains logic or is there a more...
morenrx1

Discussions |
Jan 16, 2020 9:16 PM

4335 views | 7 replies
Formulas similar to Frequently used excel formulas in JMP

How to enter a formula similar to sumif, count if and vlookup in jmp
Sivaguru

Discussions |
Jan 16, 2020 6:41 AM

4164 views | 1 replies
Help with Scripting to Compile Parameters from Curve Fit

I am in need of help editing a script originally developed to pull microbial growth parameters from a Logistic 4P model (Fit Curve Platform). I would like to edit the script to pull parameters from each treatment "strain, media, replicate", see desired output for what I would like. I am obviously missing some important language in the script but I am not clear how to do this. A scripting answer wo...
kprobst100101

Discussions |
Jan 16, 2020 5:12 AM

2583 views | 3 replies
How do I include multiple point batch test results in full factorial DOE design ?

I am trying to evaluate nutrients uniformity of a batch produced by mixing four ingredients in a mechanical mixer. Want to use full-factorial design with three factors at two levels each (ingredient types, mixing speed , amount of material used) with multiple responses (nutrients - iron, copper, etc.).Full Factorial 2 * 2 * 2 design = 8 unique trialsProduct from each trial is packaged into two bag...
hbansal

Discussions |
Jan 16, 2020 5:00 AM

3788 views | 4 replies

Previous
Next

Latest Discussions

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

2019 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

1666 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1603 views | 0 replies
Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1681 views | 0 replies
How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

2078 views | 0 replies