JMP User Community

Latest Discussions

JSL - Escape Character Syntax Error?

Hi all, (JMP Pro 17 user) I am running into a strange issue where escape characters don't work in JSL, specifically within Application Builder. This works: // Example: Python Submit("print(dt1)");This does not work: // Example: Python Submit("\[print (dt1)]\"); // this is what I want to use it with, statement is impossible without escape characters: Python Submit("\[ dt1 = dt1[~dt1["Column 1"].s...
CircularHazard2

Discussions |
Jul 16, 2024 10:29 AM

1632 views | 3 replies
Empty/Strange Python object after retrieving via Application Builder Script

Hi everyone, (JMP 17 Pro user) I am encountering a strange issue when attempting to pass data table objects to Python and retrieve them back into JSL, specifically while using Application Builder. As this is the first time I've used Application Builder, I wrote out a rough draft of the behavior I wanted in the app via a standard JSL script (for context, the goal is an application that allows use...
CircularHazard2

Discussions |
Jul 16, 2024 8:12 AM

1312 views | 2 replies
Resizing Data Box

Is there a way to fix/resize by user the size of the data box?
Currently the size of the box is set automatically due to the objects in the window. dt = Open("$SAMPLE_DATA/Big Class.jmp"); New Window("A", H List Box( V List Box(dt << New Data Box(), obj = dt << Bivariate(Y(:Weight), X(:Height))), Spacer Box(<<size(30, 0)) ) );
tom_abramov

Discussions |
Jul 16, 2024 6:37 AM

6412 views | 11 replies
ANOM

I have an ANOM summary report I generated in JMP. I wanted to extract the Group means in each row of the report and save to a new data table (Run Chart) using JSL scripting, any help ?
kd_kel

Discussions |
Jul 15, 2024 10:47 PM

2316 views | 4 replies
How to apply a formula to all columns in another table?

I am trying to take a table and apply a moving average to every function to every column. The script below is what I am trying, based on what I saw in another thread here. The goal is to make a new table and then apply the function while referencing the original. However, I keep getting a scoped data table access error. Test = Open("C:\Users\abrokaw\Desktop\JMP MA Test Table.jmp"); //open value...
GroupEdgeColt67

Discussions |
Jul 15, 2024 9:02 AM

1409 views | 3 replies

Previous
Next

Latest Discussions

How to apply a formula to all columns in another table?

I am trying to take a table and apply a moving average to every function to every column. The script below is what I am trying, based on what I saw in another thread here. The goal is to make a new table and then apply the function while referencing the original. However, I keep getting a scoped data table access error. Test = Open("C:\Users\abrokaw\Desktop\JMP MA Test Table.jmp"); //open value...
GroupEdgeColt67

Discussions |
Jul 15, 2024 9:02 AM

1409 views | 3 replies
Turn off "Suppress Eval" on all columns

Is there a way to turn off "Suppress Eval" for all columns? (It seems to have automatically turned on "Suppress Eval" when I saved a .jrp, and I need to evaluate many formula columns in this data table.)
MarkJSchwab

Discussions |
Jul 15, 2024 6:39 AM

1991 views | 4 replies
SQL Query Case Sensitivity Issue

I'm using JSL to retrieve data from a MySQL database. However, I've encountered an issue where the filtering conditions in my SQL query are case-insensitive by default. This means that the results returned are the same regardless of the case of the filter value.

Here are the two scripts that produce the same results:
Script 1:
New SQL Query(
Version( 130 ),
Connection(
"ODBC:DATABASE=my_database;DSN=my_...
Arthur

Discussions |
Jul 15, 2024 2:17 AM

2402 views | 5 replies
How does one perform Bitwise operations in JMP formulas?

Hi, I imagine this is simply an issue in which I am not finding the correct formula option but how does one perform basic bitwise operations in a JMP formula? e.g. Here's an example Python example that I would like to replicate in JMP: lambda x: ((((x>>1)&0x1))<<2) thanks, Ross
docrossus

Discussions |
Jul 11, 2024 3:18 PM

4566 views | 6 replies
Issue with Function() default local and Each functions

I have already contacted JMP support about this and this has been marked as a bug. Here is simple "real" case where this bug could be seen Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); f2 = function({}, {Default Local}, Summarize(dt, uniq_values = by(:sex)); all_sex_values = dt[0, "sex"]; //dt = dt; // don't remove, it just works For Each({uniq_value}, uniq_values,...
jthi

Discussions |
Jul 9, 2024 10:57 PM

1326 views | 1 replies

Previous
Next

Latest Discussions

Tracking down a cycle error

When I open a data table, I get a cycle detected error that I have to ignore every time. I can't seem to figure out what is causing the error although it apparently has something to do with the table variable in my column formula. Here is the formula: and here is the log entry showing the issue Can anyone help me understand what is going on here? The data table actually works fine after I click ...
scott1588

Discussions |
Jun 24, 2024 11:47 AM

1099 views | 0 replies
How do I make scattorplot Matrix with multiple cloumns I select?

Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...
NagneTE1

Discussions |
May 27, 2024 5:18 PM

787 views | 0 replies
graph builder bug - x group shift

(JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...
ShlomiB76

Discussions |
Apr 14, 2024 12:08 AM

720 views | 0 replies
Project ignoring H Splitter Box Set Sizes . . . sometimes

I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...
ionatx

Discussions |
Apr 4, 2024 1:25 PM

710 views | 0 replies
Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...
sm3001

Discussions |
Mar 21, 2024 12:49 AM

933 views | 0 replies