JMP User Community

Latest Discussions

Multi file Import: Discovering Files takes too long

MFI is great - I really love it. But sometimes the low speed of the file search hurts.
If the data comes from a network drive and I want to access the folder from home office, it can take > 10 minutes for Discovering Files to find my 4 matching file out of thousand of folders/subfolders/files ... Then it's faster to open Python in parallel, write a short GLOB search and load the files one by one vi...
hogi

Discussions |
Nov 4, 2024 11:58 PM

2381 views | 5 replies
Taking Inputs from a batch file into jsl

Hi,I have a batch file with names of folders.I want to extract these folder names into jsl and open those folders. How can I do this?
vharibal

Discussions |
Nov 4, 2024 10:19 PM

664 views | 1 replies
Selecting only csv files using jsl

Hi,
I have folder with multiple folders and csv files. I would like to open only csv files and concatenate them without opening folders

I tried using Files in Directory function and opening files from folder but this opens the folders as well

Can some one please help me on this?
vharibal

Discussions |
Nov 4, 2024 8:53 PM

877 views | 2 replies
Formula for change over time

Looking for a formula to access change over time at a row level moving from left to right i want to assess the percent shift from the 1st reading to the next and then assess all following reading back against the first and the previous reading to access shift overtime. If any are downward shifts greater than or equal to 20% indicate a 1 in a result column.
DELANDJ1985

Discussions |
Nov 4, 2024 8:01 PM

603 views | 1 replies
Add custom formula and columns to Tabulate window

Hello,Is there a way to add a custom formula and column to the tabulate window? Eg: I want to add LSL, USL, and Cpk columns to the tabulate window, not the data table box.Any suggestions on how to do this would be appreciated. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); (Data Table( "Semiconductor Capability" ) << Tabulate( Add Table( Column Table( Grouping...
Jackie_

Discussions |
Nov 4, 2024 2:15 PM

1964 views | 7 replies

Previous
Next

Latest Discussions

Formula for change over time

Looking for a formula to access change over time at a row level moving from left to right i want to assess the percent shift from the 1st reading to the next and then assess all following reading back against the first and the previous reading to access shift overtime. If any are downward shifts greater than or equal to 20% indicate a 1 in a result column.
DELANDJ1985

Discussions |
Nov 4, 2024 8:01 PM

603 views | 1 replies
Add custom formula and columns to Tabulate window

Hello,Is there a way to add a custom formula and column to the tabulate window? Eg: I want to add LSL, USL, and Cpk columns to the tabulate window, not the data table box.Any suggestions on how to do this would be appreciated. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); (Data Table( "Semiconductor Capability" ) << Tabulate( Add Table( Column Table( Grouping...
Jackie_

Discussions |
Nov 4, 2024 2:15 PM

1964 views | 7 replies
sendtoPPT - in graph builder Toolbar: (by Hogi) how is the workflow? What steps are required? Mark graph in JMP and than paste in powerpoint? ... somehow it is not working for whatever reason.
PS_Ato

Discussions |
Nov 4, 2024 1:49 PM

591 views | 1 replies
Generalized linear model output

Where in the JMP output for a generalized linear model do I find the means and standard errors for each level of the independent variables? (What is called "Effect Details" in the general linear model output)
gkolluru

Discussions |
Nov 4, 2024 7:04 AM

1047 views | 3 replies
How can I quickly reassemble and generate different tables from many JMP tables?

There are now 2400 such JMP files in the same directory C:\8: JMP tables with file names with detailed time stamps and 5000 rows of data each.For example, C:\8\20241031112503.JMP.S5 E5 S4 E4 S3 E3 S2 E2 S1 E1 B1 T1 B2 T2 B3 T3 B4 T4 B5 T5 enco 6024 2 6023 10 6021 6 6020 96 6019 18 6018 400 6017 16 6016 78 6015 41 6014 8 603198 1263 88 1262 290 1261 254 1260 347 1259 301 1258 544 1257 364 1256 630...
lala

Discussions |
Nov 3, 2024 11:43 PM

1490 views | 7 replies

Previous
Next

Latest Discussions

Error add-in manager :AddinID == selectionID

I am taking the above error once i click to build currently selected add-in button at the add-in manager. Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...
Georgios_Tsim

Discussions |
Oct 29, 2024 6:41 AM

534 views | 0 replies
JMP 18 Addins on Server - Change in Location

FYI from JMP tech support: If you are running JMP on a server, note that JMP 16 addins do not work for JMP 18 because the file paths have changed. JMP is no longer part of SAS so the file path changed from C:\ProgramData\SAS\JMP\addIns to C:\ProgramData\JMP\JMP\addIns

Changing your file path to C:\ProgramData\JMP\JMP\addIns will make addins visible for JMP version 18.
pmroz

Discussions |
Oct 29, 2024 5:58 AM

583 views | 0 replies
How do I replace a prediction expression in a fit model with a specific expression?

Hi, I am completing a DOE and I have ran a fit model using the JMP software to define a design space based on desirability of certain variables, however one of the desirability variables is a simple ratio of two of the construct model effects, however when running the model, the model is defining its own prediction expression for this variable rather than using the formula in the data table. Does ...
supermackie93

Discussions |
Oct 24, 2024 5:40 AM

499 views | 0 replies
One-Versus-Rest (OVR) and the One-Versus-One (OVO) LDA

Hello, I'm looking for a way to test a different LDA strategy than the standard One-off (or hand-out) method when trying to predict a categorical response with multiple classes. I'm particularly interested in the One-Versus-Rest (OVR) (also referred to as One-Versus-All or OVA) and the One-Versus-One (OVO) strategies. So, instead of using the default One-off LDA which seeks to solve the classica...
Quentin26

Discussions |
Oct 24, 2024 1:29 AM

701 views | 0 replies
Graph Builder: Ordering my overlay by descending order according to the total value of each overlay category

Hello community, I come to you with a difficult question. Please see the image below for reference. I am using JMP 18, and I am trying to create a bar chart to show PPB values by quarter for various categories. The trouble I run into is that I want the category that has the highest total value from the chart to be on the bottom of the stack. For example, in the image below the category memory shou...
AttributedMouse

Discussions |
Oct 22, 2024 1:37 PM

517 views | 0 replies