JMP User Community

Latest Discussions

Convert Column to numeric continuous Date - using Format Pattern - Bug?

Hi, I have the following input data table, attached input_table.jmp, which is treated by my script, see below or attached after_import_analysis_script.jsl. I want to convert col 1 (character, nominal, input format "<DD>/<MM>/<YY> <hh>:<mm>:<ss>") to Date (numeric, continuous, output format "<DD>.<MM>.<YY> <hh>:<mm>:<ss>"). However if I use my script then the conversion is wrong in the rows from 26...
RobDoubleU

Discussions |
May 5, 2025 5:47 AM

1066 views | 2 replies
Loop to set a normalization formula for several columns

Hi community, I'm trying to write a JSL script to set a normalization formula with dynamic column reference. What's wrong here?
"Mean(M4_pop)" & "Std Dev(M4_pop)" are fix columns that are to be used for the normalization.

dt = Current Data Table(); numCols = dt << Get Column Names( Numeric, "String" ); For( i = 1, i <= N Items( numCols ), i++, colName = numCols[i]; normColName...
David_Hanslian

Discussions |
May 5, 2025 12:28 AM

1094 views | 3 replies
How can increase the functionality of the JSL script editor?

1, in this script range, automatically highlight other content that is the same as the selected content;
2. How do I change the background color of the selected content when the script editor is in dark mode? Thanks!
lala

Discussions |
May 4, 2025 12:12 AM

2191 views | 11 replies
Get distinct entries from a list?

is there a simple way to obtain the distinct entries in a list? (similar to summary of a table by grouping column in order to get distinct entries in that column)
The result could be either a reduced list containing only the distinct entries (repeated ones removed) or just a number showing the amount of different entries.
Before writing a script I would like to check if there is a simple way / funct...
katharina_l

Discussions |
May 3, 2025 8:15 AM

4888 views | 14 replies
Add Counter for Unique Cases in Groups

Hi all, How can I write an integer value counter to increment unique values in column B within group A, to do this? Here is what I have tried so far: dt_Table1 = Data Table("Table1"); dt_Table1 << New Column("Dataset", Numeric, "Nominal", Set Selected); Sum1 = dt_Table1 << Summary(Group(:Group, :Date)); Sum2 = Sum1 << Summary(Group(:Group)); :N Rows << Set Name("N Datasets in Group"); dt_Tab...
StumptownSlash

Discussions |
May 3, 2025 8:01 AM

5179 views | 11 replies

Previous
Next

Latest Discussions

How can increase the functionality of the JSL script editor?

1, in this script range, automatically highlight other content that is the same as the selected content;
2. How do I change the background color of the selected content when the script editor is in dark mode? Thanks!
lala

Discussions |
May 4, 2025 12:12 AM

2191 views | 11 replies
Add Counter for Unique Cases in Groups

Hi all, How can I write an integer value counter to increment unique values in column B within group A, to do this? Here is what I have tried so far: dt_Table1 = Data Table("Table1"); dt_Table1 << New Column("Dataset", Numeric, "Nominal", Set Selected); Sum1 = dt_Table1 << Summary(Group(:Group, :Date)); Sum2 = Sum1 << Summary(Group(:Group)); :N Rows << Set Name("N Datasets in Group"); dt_Tab...
StumptownSlash

Discussions |
May 3, 2025 8:01 AM

5179 views | 11 replies
Extract words from String Column

How do I create an Output1 column to extract all the words starting with "_D" from a column called String1? String1 Output1 PRD_D30405_v1 D30405 PRD_MH1_D4375 D4375 FET-D3245_v2_D43453 D43453 BDT_33tr-ge_DT3746_v2 DT3746
cchueng

Discussions |
May 2, 2025 9:56 PM

675 views | 2 replies
Run Program on Mac for unix "which" command

I'm trying to use the Run Program() command to execute the unix command "/usr/bin/which -a Python3". I'm still learning so sorry if the answer seems obvious. For the record, I'm running JMP Pro 17.2 on MacOS Sonoma 14.7.1. The Mac thing is important to note, as there seem to be some subtle syntax differences from PCs. Attempt 1 (just confirming Run Program works): RP = Run Program( Executab...
nikles

Discussions |
May 2, 2025 2:53 PM

1768 views | 4 replies
Couldn't install JMP Excel Add-in on Snapdragon X Elite laptop for both JMP17 and 18

Was able to install and run both JMP17 and JMP18 on Snapdragon X Elite laptop. However, having issue installing JMP Excel add-in for both. The installation stalled at the following step (https://community.jmp.com/t5/JMP-Knowledge-Base/How-to-install-or-re-install-the-Excel-Add-in-for-JMP-when-the/ta-p/575299) The installation options box now appears. Find the entry for the Excel Add-In and unchec...
ILoveJMP

Discussions |
Apr 30, 2025 5:02 PM

724 views | 2 replies

Previous
Next

Latest Discussions

Inquiry Regarding the Use of JMP and JMP Live (Suppress Eval?)

Hello, I am a user of JMP Live.
I am currently utilizing a simple function within JMP to leverage the Auto Refresh feature in JMP Live for dashboard purposes. However, while the function operates correctly on my PC, it does not work properly on JMP Live.Even though I have disabled "Suppress Eval" before executing Data Publish, when I later download the data, the column where the function should be ...
DJ_Kim

Discussions |
Feb 27, 2025 2:59 PM

561 views | 0 replies
Streamlining Data Workflows With JMP & MATLAB

Integrating tools like JMP and MATLAB offers a streamlined approach to engineering analysis, making workflows more efficient and reducing the need for redundant script rewriting. By leveraging JMP’s powerful data analysis and visualization capabilities alongside MATLAB’s robust computational tools, engineers can seamlessly combine the strengths of both platforms. This integration allows for the ra...
brycerjs8

Discussions |
Feb 18, 2025 7:07 AM

585 views | 0 replies
How to adjust the size of R plot imported with get R graphics(); ?

I'm trying to run R code in JMP to create a plot. I succeeded in importing the plot in png format, but failed to adjust the size of the plot. I can adjust the "plot_from_R" in png format with the set size(); function in jsl, but it is not proportional and distorted. How can I import plot_from_R in the size I want? R Init(); R Submit( "\[ windows(300,100) #it doesn't work plot(function(x) dnorm(...
CountableModel1

Discussions |
Jan 15, 2025 4:01 PM

621 views | 0 replies
Exceptions are the utilities Show, Write, and Print ...

from: https://www.jmp.com/support/help/en/18.1/?os=win&source=application#page/jmp/advanced-expressions-macros-and-lists.shtml# If you assign the expression x+y to a, quoting it as an expression with Expr, then whenever a is evaluated, it evaluates the expression using the current values of x and y and returns the result.
Exceptions are the utilities Show, Write, and Print, which do not evaluate e...
hogi

Discussions |
Jan 7, 2025 10:44 PM

614 views | 0 replies
Extract Expr: Issue with scoped variable

This works: Extract Expr(:height << set name( "new" ), :height ); But this one doesn't *):Extract Expr(myDataTable:height << set name( "new" ), myDataTable:height );Fortunately there is this dirty trick of Extract Expr (it automatically resolves every defined variable **) - which allows this workaround:x = Expr( myDataTable:height); Extract Expr(myDataTable:height << set name( "new" ), x ) *) why...
hogi

Discussions |
Jan 7, 2025 11:35 AM

496 views | 0 replies