JMP User Community

Latest Discussions

Remove hyperlink when opening Excel with hyperlinked cells

I am opening (code below) an excel spreadsheet which has got hyperlinked entries in a particular column. Hyperlinks for each entry point to another excel spreadsheet. JMP 16.2 is loading these entries with a blue underline and this is causing me issues in data manipulations downstream. I want to load the data for this column as Charecter/Norminal. How to achieve this?Thanks.Names Default To Here( ...
Neo

Discussions |
Mar 4, 2024 11:15 AM

2704 views | 6 replies
Neural networks that learn and predict in real time (incremental learning)

Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco
Marco2024

Discussions |
Mar 4, 2024 9:37 AM

716 views | 0 replies
Multiple regression or Two-way ANOVA

Hello!
I have set of data that includes different cell groups, cultured over 16 days. the cell count is measured every 2 days (sampling days)
I'm looking at multiple regression to check the difference in the cell group*sampling days. I have a total of 9 sampling days and 7 cell groups. my problem is that my parameter estimates do not show the last sampling period (eg. cellgroup1*day 16, cellgroup2*d...
ReyrieNeedshelp

Discussions |
Mar 4, 2024 8:01 AM

2319 views | 2 replies
prompt the user to choose a certain date and then use it for the local data filter [using JSL]

Hi, I have a date column in the mmddyyyy format. I need to print it out to the user to choose from and then use a local data filter to filter the selected dates in Graph builder. The issue I'm having is that when I try to print the data to the user, it shows it as a long integer that I can't understand. Any suggestions is appreciated. I have attached a picture of the date column from the data ta...
RA899

Discussions |
Mar 4, 2024 6:36 AM

2152 views | 4 replies
When JMP mapping, how can I load an image with a transparent background to keep the background transparent?

JMP maps the following JSL and then loads the transparency image with a transparent background.Save as a new image, how to use JSL?dt=Open("$SAMPLE_DATA/Big Class.jmp"); p1 = dt << Graph Builder( Variables( X( :weight ), Y( :height ), Group X( :age ), Color( :sex ) ), Elements( Bar( X, Y, Legend( 5 ), Response Axis( "X" ) ) ) );Thanks!
lala

Discussions |
Mar 4, 2024 12:17 AM

1240 views | 1 replies

Previous
Next

Latest Discussions

Neural networks that learn and predict in real time (incremental learning)

Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco
Marco2024

Discussions |
Mar 4, 2024 9:37 AM

716 views | 0 replies
When JMP mapping, how can I load an image with a transparent background to keep the background transparent?

JMP maps the following JSL and then loads the transparency image with a transparent background.Save as a new image, how to use JSL?dt=Open("$SAMPLE_DATA/Big Class.jmp"); p1 = dt << Graph Builder( Variables( X( :weight ), Y( :height ), Group X( :age ), Color( :sex ) ), Elements( Bar( X, Y, Legend( 5 ), Response Axis( "X" ) ) ) );Thanks!
lala

Discussions |
Mar 4, 2024 12:17 AM

1240 views | 1 replies
How to use wildcards in matching columns (Update Table)

Hi all,How can I update a table using wildcard? I already tried to create a column with a substring formuladt << New Column( "Code Ref", Formula (Substr(:Code, 1, 4)) );TableACodeNameAgeABCD456Ann12ABCD123Roy16ABCD678Jean11 TableBCodeNameAgeABCD543John12FGR263Mike13ABCD975Rose8 After table update:CodeNameAgeABCD456Ann12ABCD123Roy16ABCD678Jean11ABCD543John12ABCD975Rose8 But I cannot use Code Ref as...
UserID16644

Discussions |
Mar 3, 2024 11:17 PM

1173 views | 2 replies
Histogram with filter

HiI'm trying to plot a histogram that shows the full data. on it, I want to plot two vertical lines that represent lower and upper limits. Additionally, I want to present the mean and the std of the data in these limits and the fraction of the data that is in the limit. Something like this:Thanks
Gerakolt

Discussions |
Mar 3, 2024 6:49 AM

1185 views | 2 replies
Get Script after User Input and Script to String

Hello Guys,New to jmp scripting. I require assistanceI want to get the script after user specifies the valid informationdt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" ); obj = dt << Variability Chart(); // I want to get Script after User clicks OK How to do thatIf i have a string and to run it as script i do this dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" ); theScript = "Variab...
ComplexNerd

Discussions |
Mar 2, 2024 10:11 AM

1378 views | 3 replies

Previous
Next

Latest Discussions

Neural networks that learn and predict in real time (incremental learning)

Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco
Marco2024

Discussions |
Mar 4, 2024 9:37 AM

716 views | 0 replies
ann armax model

how can make ann armax hybrid model such Matlab
Raaed

Discussions |
Mar 1, 2024 7:50 AM

712 views | 0 replies
Is there a way to change the defaults for the Summary platform?

Hi All, Does any know if it's possible to change the defaults of the Summary platform (Tables > Summary)? By default, Summary sets the new column names to be stat(column) and checks that the new data table is linked to the original data table. For much of the work I do, I don't like these features and wish I didn't have to change them every time I run a Summary. I know it can be useful at tim...
SDF1

Discussions |
Feb 29, 2024 8:08 AM

622 views | 0 replies
How do you get the confidence intervals output for performance measures in the add ins imbalanced misclassification?

I am wondering if you can let me know how can I get the performance measure Confidence Intervals (lower and the upper limit) and the alpha when I do the add ins imbalanced classification analysis to evaluate models (I picked all the models [except for generalized regression] and sampling techniques). I am able to get the PR Curve AUC, ROC Curve AUC, but I am not able to locate how to get the confi...
NishaKumar

Discussions |
Feb 22, 2024 8:44 AM

668 views | 0 replies
group file name and set lable by JSL looping, work fine but slowly

I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...
BayesRabbit7133

Discussions |
Feb 22, 2024 12:24 AM

728 views | 0 replies