JMP User Community

Latest Discussions

how to use jsl to read json file time column

I'm trying to use jsl to open a json file. The json file has a time column in the format of yyyy-mm-ddThh:mm:ss, but I'm struggling how to read it correctly. I tried to use this but it was not workingOpen(path1,JSON Settings(
Stack( 0 ),
Row( "/root/value" ),
Col("/root/value/datetime",
Column Name( "datetime" ),
Fill( "Use Once" ),
Type( "Numeric" ),
Format( "yyyy-mm-ddThh:mm:ss" ),
Input format ( "yyyy...
emmablue

Discussions |
Jul 2, 2024 8:28 AM

2922 views | 7 replies
Columns containing numbers and numbers with a letter

Dear JMP community,I have a problem with opening a data table and I use the JMP 17 version.I have a data table (xlsx file) with many columns containing numbers and strings. Some of the columns contain both numbers and strings. My problem is, when JMP opens a column of a data table and in the first row there is a number and in the remaining rows there are numbers with an initial letter (e.g. R4562)...
Silver22

Discussions |
Jul 2, 2024 3:14 AM

2414 views | 5 replies
Shortcut to select/highlight variable name

Before the JMP16 Name() parser change for variable names (examples shown below), the Ctl+ ] keyboard shortcut would highlight/select the entire variable name and the bounding (). This was very convenient for copying/pasting variable names in my JSL code. Does a similar or new keyboard shortcut exist that does the same thing but for the newly constructed variable name? That is, highlight/select ...
terapin

Discussions |
Jul 2, 2024 2:07 AM

984 views | 1 replies
How to Show Header Graphs Using JSL?

Is there any way to set the Header Graphs to show using JSL? I've searched the Scripting Index & help forums, and trieddt << Show Header Graphs(1);and similar variations with no luck. Thanks!
mmt

Discussions |
Jul 2, 2024 12:30 AM

3100 views | 7 replies
Insert 0 if missing Data

Hello Community, I searched for, but I can't find a skip in the Community. I Looking for a Script, which simply make out of all missing Datas in my data table a "0" (Zero). Thanks in advanceAndrea
voy-voy

Discussions |
Jul 1, 2024 1:26 PM

3072 views | 4 replies

Previous
Next

Latest Discussions

Columns containing numbers and numbers with a letter

Dear JMP community,I have a problem with opening a data table and I use the JMP 17 version.I have a data table (xlsx file) with many columns containing numbers and strings. Some of the columns contain both numbers and strings. My problem is, when JMP opens a column of a data table and in the first row there is a number and in the remaining rows there are numbers with an initial letter (e.g. R4562)...
Silver22

Discussions |
Jul 2, 2024 3:14 AM

2414 views | 5 replies
Shortcut to select/highlight variable name

Before the JMP16 Name() parser change for variable names (examples shown below), the Ctl+ ] keyboard shortcut would highlight/select the entire variable name and the bounding (). This was very convenient for copying/pasting variable names in my JSL code. Does a similar or new keyboard shortcut exist that does the same thing but for the newly constructed variable name? That is, highlight/select ...
terapin

Discussions |
Jul 2, 2024 2:07 AM

984 views | 1 replies
Storing data tables as metadata (table variables) JSL

Table variables are used to store metadata within a data table (JSL doc, general doc) However, they seem to be limited to variables as strings only (see code below). What would be the best option to store a data table as a table variable? Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt_metadata = Open( "$SAMPLE_DATA/Solubility.jmp" ); dt << Set Table Variable( "dt_user...
FN

Discussions |
Jul 1, 2024 9:25 AM

2395 views | 6 replies
JSL MouseBox doesn't save to Journal JMP 17 vs JMP 16

Hello, I am using a scrip that saves a report in a journal and have noticed a change between JMP 16 and JMP 17 that breaks some of its functionality. If I save a window to the journal in JMP 16, the MouseBox interactions work just like they did in the JMP window, but in JMP 17 I've found that MouseBox doesn't save to the journal at all. Is this an intended change? Any ideas on possible workaroun...
CitizenNo3

Discussions |
Jun 27, 2024 5:13 PM

1959 views | 4 replies
How can I achieve automated analysis through scripting languages

I have been getting started with scripting languages recently, and I want to use editing languages to automate the equivalence testing of reduced models. However, after the equivariance test, it is unclear how to use script language editing to enable the software to select equivariance or unequal variance equivalence tests based on Levene results .
LikelihoodFawn8

Discussions |
Jun 27, 2024 5:07 AM

873 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

1100 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