JMP User Community

Latest Discussions

How to script "save difference summary" of "compare data tables"

Hi,

I have a script that calls the compare data tables platform using:DTOriginal << Compare Data Tables(Compare with( DT2new ),Hide columns with no differences( 0 ),Hide rows with no differences( 0 ));After I can manually use the top left red triangle to "save difference summary", however this isn't recorded in the log or workflow builder. Can it be scripted and if so, how?
david707

Discussions |
Jul 31, 2024 2:39 AM

822 views | 1 replies
Change Date format

There is an error as I cannot run this, can anyone help?// Function to reformat dates to dd/mm/yyyy
colName = Column Dialog( "Select Date Column" );
reformatDateColumn = Function({dt, colName},
dt = Current DataTable();If( Column( dt, colName ) == Empty(),
Throw( "The selected column does not exist in the current data table." );
);// Function to identify and reformat the date
formatDate = Function({date...
DecileIbex201

Discussions |
Jul 30, 2024 9:51 PM

1101 views | 2 replies
Select all the points shown in graph builder?

I have this data in graph builder and I was wondering if there was a way with JSL to select all the points that are showing in the current GB arrangement? This would save me from having to hold down control and select all the point in each panel by panel. On some GB arrangements this can be a lot of panels to work through!
shampton82

Discussions |
Jul 30, 2024 3:01 PM

873 views | 1 replies
Make JSL script more efficient for sampling a 'sliding window'

Hello, I'm trying to create a script that will sample a data table with a 'sliding window' (sampling a set number of rows of a set 'width', then moving up a row to sample the next set, resulting in a data set of rows 1-10, 2-11, 3-12 and so forth) sampling of my data table, creating a new data set that I can use for pattern analysis. My script is operational, but doesn't work well for larger dat...
33909

Discussions |
Jul 30, 2024 4:34 AM

976 views | 2 replies
JMP 18 JSL cannot add spec to column property

Hi, My jsl to add spec to column properties failed on the new JMP 18. I've been using it successfully on JMP 17.Eval( Eval Expr( dt:(collist[i]) << Set Property("Spec Limits", {LSL(Expr(LSL)), USL(Expr(USL)), Target(Expr(TARGET)), Show Limits(Expr(Show_Limit))}) << Set Property("Units",Expr(UNITS)) ) );The "Spec Limits" property shown up in the column but there is no value (USL, LSL, Tar...
dntt

Discussions |
Jul 29, 2024 10:43 PM

1384 views | 3 replies

Previous
Next

Latest Discussions

How to script "save difference summary" of "compare data tables"

Hi,

I have a script that calls the compare data tables platform using:DTOriginal << Compare Data Tables(Compare with( DT2new ),Hide columns with no differences( 0 ),Hide rows with no differences( 0 ));After I can manually use the top left red triangle to "save difference summary", however this isn't recorded in the log or workflow builder. Can it be scripted and if so, how?
david707

Discussions |
Jul 31, 2024 2:39 AM

822 views | 1 replies
Change Date format

There is an error as I cannot run this, can anyone help?// Function to reformat dates to dd/mm/yyyy
colName = Column Dialog( "Select Date Column" );
reformatDateColumn = Function({dt, colName},
dt = Current DataTable();If( Column( dt, colName ) == Empty(),
Throw( "The selected column does not exist in the current data table." );
);// Function to identify and reformat the date
formatDate = Function({date...
DecileIbex201

Discussions |
Jul 30, 2024 9:51 PM

1101 views | 2 replies
Select all the points shown in graph builder?

I have this data in graph builder and I was wondering if there was a way with JSL to select all the points that are showing in the current GB arrangement? This would save me from having to hold down control and select all the point in each panel by panel. On some GB arrangements this can be a lot of panels to work through!
shampton82

Discussions |
Jul 30, 2024 3:01 PM

873 views | 1 replies
Make JSL script more efficient for sampling a 'sliding window'

Hello, I'm trying to create a script that will sample a data table with a 'sliding window' (sampling a set number of rows of a set 'width', then moving up a row to sample the next set, resulting in a data set of rows 1-10, 2-11, 3-12 and so forth) sampling of my data table, creating a new data set that I can use for pattern analysis. My script is operational, but doesn't work well for larger dat...
33909

Discussions |
Jul 30, 2024 4:34 AM

976 views | 2 replies
Open jmp file from Teams/Sharepoint on publicly used script

Opening a jmp file from Microsoft Teams/Sharepoint is simple enough if I'm the only one using the script. I just go into Teams and click "Add Shortcut to OneDrive" and then am able to map to the file as shown below. dt = Open("C:\Users\{username}\OneDrive - {company}\Data\Table.jmp");The problem I'm having is that I want this script to be usable by others in the company. I could make {username} a ...
mtrensch

Discussions |
Jul 29, 2024 2:48 PM

1887 views | 2 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

1098 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

784 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

718 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

709 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

932 views | 0 replies