JMP User Community

Latest Discussions

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

1422 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

7931 views | 9 replies
Keep column customised order after concatenation with other columns

Hello, I have attached a JMP table to reproduce my problem. In my example, I have 3 columns:Column 1: takes the values 'A', 'B', 'C'. I've customized the order of the values so that if I sort it's not A> B> C but B>C>A.Column 2: takes values 1,2,3,4. No custom order
Column 3: Is the concatenation of Column 1 || Column 2 . But if I sort, it will be in alphabetical order and won't take into account t...
SophieCuvillier

Discussions |
Mar 29, 2024 6:49 AM

1358 views | 2 replies
How can I parse a string in 1 column use jsl?

I want to use jsl to split data in column "result" with delimiter "|" to new column "PIN" and "value". Kindly help, thank you in advancePlease refer my attachmentnew table
ducthinh279

Discussions |
Mar 28, 2024 9:04 PM

4229 views | 7 replies
Accessing summary of fit when By argument is used

Hi, I make a summary of fit table by using the script: Names Default To Here( 1 ); dt = Data Table("Big Class Data"); biv = dt << Bivariate( Y( :weight ), X( :height ), Fit Line(), //By(:sex), ); rpt = biv << Report; rpt["Bivariate Fit of weight By height?", "Linear Fit", "Summary of Fit",Table Box( 1 )] << Make Combined Data Table; However, I don't understand why the same...
gam1

Discussions |
Mar 28, 2024 6:58 AM

1073 views | 1 replies

Previous
Next

Latest Discussions

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

7931 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

3048 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

1405 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
expression column with list compare to given list to replace with desired value

Hi,is there a method through add new formula to column for issue below?

I have a column that is list value and I want to compare to given list, if element from list in column match to given list then replace that single element with "1". Below are example. The given list is {"aa", "app", "b", "pp", "zzzz"}
dadawasozo

Discussions |
Mar 23, 2024 10:59 AM

1613 views | 3 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

932 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

942 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