JMP User Community

Latest Discussions

Column() vs As Column() vs datable:column vs dt:As name("column")

JSL has several ways to refer to columns. Let's open a data table first. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Bands data.jmp" );Now we create a table script that has something like this.dt = current data table(); print(dt:timestamp == Column(dt, "timestamp")); // 0 print(Column(dt, "timestamp")==As Column(dt, "timestamp")); //0In automated scripts (for example, a graph), when a...
FN

Discussions |
Mar 30, 2024 11:54 AM

7320 views | 13 replies
Using a string variable inside a graph builder script

Early in my JMP script, I define a string variable like this: Trim0 = "trim_lvl_a";There is a column in my data table by the name of trim_lvl_a. Later in the script, I create a Graph Builder script like this: dt << New Script( "maps", Graph Builder( Size( 550, 647 ), Graph Spacing( 5 ), Variables( X( :X ), Y( :Y ), Group Y( :Name( "Tambient (degC)" ) ), Wrap( :LotWafer ), Col...
fbm73

Discussions |
Mar 29, 2024 2:55 PM

1204 views | 1 replies
how to get Plot of several Plots time vs dimensions

I would like to have a script for the dimension control by time, for this I need something like the sketch below. The Date Table is attached. In total there are 49 plots in one plot, 7 time points and 7 dimensions, some of the dimensions are measured in different points (a,b,c,d) then each points should have a certain color. Thank you everyoneJMP17
Mendes-Burak

Discussions |
Mar 29, 2024 9:07 AM

1520 views | 3 replies
New Column to show repeated values in for each run/ID across two data types

I tried using lag function to indicate when the first test for a sample ID based on time column. Need to the column, Order Tested, to represent first test conducted for a sample ID and second test based on time. Each test will have a real and maybe a code value. See attached file for JMP file. At the end of the day Order Tested column needs to look like image below. This is just a sample, real one...
VT23

Discussions |
Mar 29, 2024 8:59 AM

1420 views | 2 replies
ChatGPT JSL Script

I'm not very proficient at JSL scripting so, as a test, I asked ChatGPT-4 to write a JSL script for me. I used the "Corn, Wheat, Soybean Production" data table from the JMP sample data. My request was: "I have a dataset to analyze corn, wheat and soybean production. It consists of 5 columns (Year, State, Commodity, Commodity acres planted, and total acres planted). Can you generate a JMP JSL scrip...
scott1588

Discussions |
Mar 29, 2024 7:19 AM

7928 views | 9 replies

Previous
Next

Latest Discussions

how to get Plot of several Plots time vs dimensions

I would like to have a script for the dimension control by time, for this I need something like the sketch below. The Date Table is attached. In total there are 49 plots in one plot, 7 time points and 7 dimensions, some of the dimensions are measured in different points (a,b,c,d) then each points should have a certain color. Thank you everyoneJMP17
Mendes-Burak

Discussions |
Mar 29, 2024 9:07 AM

1520 views | 3 replies
ChatGPT JSL Script

I'm not very proficient at JSL scripting so, as a test, I asked ChatGPT-4 to write a JSL script for me. I used the "Corn, Wheat, Soybean Production" data table from the JMP sample data. My request was: "I have a dataset to analyze corn, wheat and soybean production. It consists of 5 columns (Year, State, Commodity, Commodity acres planted, and total acres planted). Can you generate a JMP JSL scrip...
scott1588

Discussions |
Mar 29, 2024 7:19 AM

7928 views | 9 replies
Searching every cell in one column to find a specific content

Hi all, I have a jmp data table with a column that contains different strings at each row. I would like to know if I can loop that column to find a specific part of the string in that cell. This an example of the strings: Class: 10 Table:15 Stat:NA loc:NA teacher:Sam --> content of the cellClass: 11 Table:11 Stat:NA loc:NA teacher:Sam The challenge is that I have different class # and different...
RA899

Discussions |
Mar 27, 2024 10:05 PM

3047 views | 6 replies
How can you do this faster with JSL?

Require these characters to be replaced with the result in the diagram<a href="/shiju/chuntian/">A11</a></li><li><a href="/shiju/chongyangjie/">C22</a></li><li><a href="/shiju/laoshi/">D3</a></li><li><a href="/shiju/juhua/">B0</a></li><li><a href="/shiju/libie/">B1</a>
Explanation: This kind of data is very large.
I replaced slower with the following codetx=Substitute(tx,"</a></li><li><a href=\!"/sh...
lala

Discussions |
Mar 25, 2024 7:54 AM

1404 views | 3 replies
If statement inside a graph with recalc option

Hi,I have a graph that I want to add target line per if statement (depends on user filters).1. how to apply IF inside the graph code?2. how to make the graph recalc and create the needed ref line? example (the bold is not working):Bivariate(Y( :raw_value ),X( :ah_attribute_value ),Automatic Recalc( 1 ),SendToReport(if (:FE_BE[N Row(dt)] == "FE", Dispatch({}, "2", ScaleBox, {Add Ref Line( 10, "Das...
Hamal22

Discussions |
Mar 25, 2024 7:30 AM

965 views | 1 replies

Previous
Next

Latest Discussions

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

931 views | 0 replies
DataTable Prompt in application builder on module load

Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads Kindly guide. Thanks in advance
ComplexNerd

Discussions |
Mar 7, 2024 3:54 AM

662 views | 0 replies
JMP Project Global Data Filter and Column Switcher

Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...
ComplexNerd

Discussions |
Mar 7, 2024 12:10 AM

621 views | 0 replies
"If" returns error response

I have a script to draw charts and use "if" for the reference line."Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it shows 5.How could I fix it? d6_graph=dt2 << Graph Builder( Size( 400, 300 ), Show Control Panel( 0 ), Variables( X( :Lot), Y( :dIGSS, Position( 1 ) ), Color( :Lot ), By(:Rel_Test) ), Elements( Box Pl...
LT

Discussions |
Mar 4, 2024 8:08 PM

941 views | 0 replies
Neural networks that learn and predict in real time (incremental learning)

Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco
Marco2024

Discussions |
Mar 4, 2024 9:37 AM

850 views | 0 replies