JMP User Community

Latest Discussions

Using Char to compare numeric and character values

Hi,Is it possible to compare numeric and character values? I want to compare two columns (identical or different values). One column has a numeric date and one has a character date and as I need to compare only parts of it I want to use substring. The below script runs, but it doesn´t get me the correct result as all appears to be different (which is not the case). Am I using Char wrong? If( Subst...
JulieSAppel

Discussions |
Feb 7, 2023 4:58 AM

4292 views | 8 replies
Authenticate DBC user and pass before storing them for future use

Hi,I am writing some code to pull data from an ODBC connection. I want to test if the username and password entered are valid. The script is as follows: dbc = Create Database Connection("Driver={Oracle in instantclient11_1}; DBQ=" || target || "; UID=" || user || ";PWD=" || pass || ";FBS=12800000;");I found some solutions suggesting checking if dbc is empty to see if the connection was created as ...
SivaSubram5313

Discussions |
Feb 7, 2023 4:52 AM

1590 views | 2 replies
formula not automatically evaluated until clicking apply button

Hello. I made a script adding a column with a conditional formula , the output resulted to a null column only until you click apply in the column formula, I want to automatically output it , I asked colleague to try my data and script , it worked with them. what could be the problem with my jmp16.new column("Remarks01",character,nominal,formula(If( :Remarsk00 == "Y", "1_a", "2_b" )));
sos012523

Discussions |
Feb 6, 2023 11:57 PM

1585 views | 2 replies
Substituting a space for underscore in a character string

Hi:

I have a long description of a product that includes a bunch of underscores __ which I don't want. I'd like to replace them with spaces instead.

I've tried using substr(substitute(columnname, "_",""),1, 999) but that just makes the entire field blank.
I've also tried the reverse (substitute(substr....) same problem. Help!

JMP 17 FWIW.
RandomMapsFox62

Discussions |
Feb 6, 2023 11:43 AM

2922 views | 2 replies
Data Filter - Zoom Settings

When I open a data filter and use "zoom to Selection" to restrict the displayed ranged, I can generate a J'SL code which looks like the one below. Unfortunately, when I run the JSL code, the Data Filter is opened without the range restriction (Jmp 17.0): Is there anything that I can do to get the range restricted? dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Data Filter( Location( {175, 175...
hogi

Discussions |
Feb 5, 2023 11:41 PM

1714 views | 4 replies

Previous
Next

Latest Discussions

Authenticate DBC user and pass before storing them for future use

Hi,I am writing some code to pull data from an ODBC connection. I want to test if the username and password entered are valid. The script is as follows: dbc = Create Database Connection("Driver={Oracle in instantclient11_1}; DBQ=" || target || "; UID=" || user || ";PWD=" || pass || ";FBS=12800000;");I found some solutions suggesting checking if dbc is empty to see if the connection was created as ...
SivaSubram5313

Discussions |
Feb 7, 2023 4:52 AM

1590 views | 2 replies
Data Filter - Zoom Settings

When I open a data filter and use "zoom to Selection" to restrict the displayed ranged, I can generate a J'SL code which looks like the one below. Unfortunately, when I run the JSL code, the Data Filter is opened without the range restriction (Jmp 17.0): Is there anything that I can do to get the range restricted? dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Data Filter( Location( {175, 175...
hogi

Discussions |
Feb 5, 2023 11:41 PM

1714 views | 4 replies
How to exclude rows based on a formula like in excel

Hello All, I have not run anything in JSL, as so far everything I've needed has been available as a series of buttons in the existing UI. I am hoping that what I want is still in that realm, but if it isn't, I could use instructions that a child could follow. I want to be able to write a formula in the data filter that would exclude anything that either satisfies (or doesn't satisfy) that formula....
Blueseashell3

Discussions |
Feb 3, 2023 7:41 AM

3397 views | 2 replies
How to make Dashboard of Dashboards without keeping datatables open in memory?

I have a 500 item dataset, each one made up of about 500,000 data points. I want to make a report from each sub dataset and present the overall results of the 500 items with all of the resolution. The trival way is to make a dashboard/app of multiple datatables, but even if hidden they still take up memory and this is not an option. The end dashboard should give insights to notice issues within su...
John89

Discussions |
Feb 3, 2023 2:28 AM

1057 views | 1 replies
Control New Window Location with Multiple Monitors

When I use JMP with multiple monitors, it tends to open pop-ups/new windows on displays other than the one I am using, oftentimes moving aside other content that I am referencing. Is there a way to control the location of new windows - for example, when I click "column info", a new window will appear and often it is not in the same display where the data table is located....I cannot find any sett...
ateran

Discussions |
Jan 28, 2023 12:35 AM

2061 views | 3 replies

Previous
Next

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

913 views | 0 replies
C Stack Usage Error When Sending Code to R

Hello, I'm trying to invoke some commands in R using the R Submit function in JSL and am getting the error below. Is this an issue with JMP17 and R integration? It only happens when I invoke a specific package using JSL so it's hard for others to replicate w/o installing R and the package as well. I'm using JMP 17.0 and R 4.2.0. Never saw this error with JMP 16. "Error: C stack usage 4123778 is to...
vigslayer

Discussions |
Dec 15, 2022 8:14 PM

1102 views | 0 replies
How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...
SquaresDingo505

Discussions |
Oct 24, 2022 7:23 PM

866 views | 0 replies
How to Analyze and Graph Responses with Supercategories

I use JMP Pro 16. I am doing MCA on 90 columns that have supercategories. I want to do the analysis and viz on the supercategory classification. Is there a way to do this without having to create separate columns that only have the supercategory classification? PS: I don't know how to do JSL scripting.
TCM

Discussions |
Oct 21, 2022 5:59 AM

910 views | 0 replies
標準化列名稱如何用變數取代求解

//新增周標準化
weekEMC_HF_C_12_0 = Data Table( "周_EMC_HF_C_12um" ) << Get Column Names( string );
weekEMC_HF_C_12 = {};
//少一周={:"2022W38"n,:"2022W40"n,:"2022W41"n};
For( j = N Items( weekEMC_HF_C_12_0 ), j >= (N Items( weekEMC_HF_C_12_0 ) - 5), j--,
Insert Into( weekEMC_HF_C_12, weekEMC_HF_C_12_0[j] )
);
Try(
Local( {old dt = Current Data Table()},
Current Data Table( Data Table( "周_EMC_HF_C_12um" ) );
For Each( ...
Ken697

Discussions |
Oct 20, 2022 9:22 PM

825 views | 0 replies