JMP User Community

Latest Discussions

Pull Data using SQL and JMP string in JSL script

Hi all.I am accessing a certain database using SQL from a JSL script.To pull the data I want, I need to provide a specification.The specification comes in the form of a list or matrix in JMP/JSL.If I manually type-in the single items names, it works. =>/* Fetch Single Items from Database*/ A = Open Database("Server Specs", "SELECT * FROM CertainFolder a WHERE a.CertainColumn IN ('A','B','C','D')"...
Valerio

Discussions |
Jul 4, 2022 12:47 AM

3159 views | 5 replies
How to replace empty rows in select columns?

Hello JMP Community, I have a data table that columns have specific name, first i wrote the script to select those columns, and i want to replace those column's empty rows with "REF", but other columns without those specific name won't change, how can i do this with JSL? Thanks.
SING

Discussions |
Jul 3, 2022 6:49 PM

2117 views | 5 replies
Get As Report - Text Justification

Hello, I am trying to justify the text to the left:VLB2<<append( Report_P = CollectionFileStacked<<Get As Report ); Report_P[Tablebox(1)] << Set Underline Headings(1); Report_P[Tablebox(1)] << Horizontal Alignment( "Left" );This doesn't seem to work, I also try to unselect specific columns with no success, the Scripting Index for the 'Get As Report' and 'Table Box' doesn't seem to be of much help....
Niros

Discussions |
Jul 3, 2022 12:37 AM

730 views | 2 replies
What do I need to run a JSL on a client pc

Can I deploy a JSL as a standalone executable? or do I need to install jump on a client box and then call jmp.exe to open it up.what license do I need to run the JSL in a client machine? I do need a full jmp license
EdwinA

Discussions |
Jul 1, 2022 8:51 PM

614 views | 1 replies
UI to select data table

Hi @txnelson , I have a jsl code which creates a new window , displays all the data table and saves the column names containing particular string in the list . It doesn't work when the current data table tab has different file (see screen shot below).The script works well when the data table file is selected in the current data table tab but doesn't work when I select the file from the list box an...
Jackie_

Discussions |
Jul 1, 2022 1:23 PM

1687 views | 1 replies

Previous
Next

Latest Discussions

Get As Report - Text Justification

Hello, I am trying to justify the text to the left:VLB2<<append( Report_P = CollectionFileStacked<<Get As Report ); Report_P[Tablebox(1)] << Set Underline Headings(1); Report_P[Tablebox(1)] << Horizontal Alignment( "Left" );This doesn't seem to work, I also try to unselect specific columns with no success, the Scripting Index for the 'Get As Report' and 'Table Box' doesn't seem to be of much help....
Niros

Discussions |
Jul 3, 2022 12:37 AM

730 views | 2 replies
What do I need to run a JSL on a client pc

Can I deploy a JSL as a standalone executable? or do I need to install jump on a client box and then call jmp.exe to open it up.what license do I need to run the JSL in a client machine? I do need a full jmp license
EdwinA

Discussions |
Jul 1, 2022 8:51 PM

614 views | 1 replies
How do you append a list onto a col list box?

The syntax is causing me confusion, I tried something similar as below. However it does not work.colbox << append(dt << mylist);
Andyon98

Discussions |
Jul 1, 2022 12:45 PM

1202 views | 4 replies
How do I combine two columns one character and one numeric?
MDB9933

Discussions |
Jul 1, 2022 11:37 AM

1001 views | 3 replies
DOE - Split Plot Designs: Does one ever include center points?

Greetings: I'm new to split plot designs, understand the basic structure and application. Does one ever include center points in such a design to detect curvature? I've searched and searched, but haven't been able to find an answer. I suspect the answer is "No", but if anyone out there can refer a document or has an answer, I'd love to know the reason. Cheers, Bruce
BSindahl

Discussions |
Jul 1, 2022 10:05 AM

2861 views | 6 replies

Previous
Next

Latest Discussions

Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

618 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

484 views | 0 replies
SUR (Seemingly Unrelated Regressions)

HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Raaed

Discussions |
May 5, 2022 4:45 PM

625 views | 0 replies
Friedman post hoc analysis

Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
pnakashe

Discussions |
May 5, 2022 12:02 PM

781 views | 0 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

554 views | 0 replies