JMP User Community

Latest Discussions

[JSL] Select rows using "Complex" conditions

Hello All, I would like to write a JSL script to select the rows in a table with “complex” conditions:I need to select ONE ROW per Metric (Column :Metric) with conditions IN ORDER OF PRIORITY: 1- if the condition Flag1 = “FLAG” AND Flag2 = “FLAG” exists, Select Col Max (:Metric1) of this condition2- if the condition Flag1 = “FLAG” XOR Flag2 = “FLAG” exists, Select Col Max (:Metric1) of this condit...
Voizingu

Discussions |
Sep 2, 2024 10:12 PM

973 views | 6 replies
Script to change data type for all columns that contain a string in their header?

I'm trying to write a script to change all the columns with the word "Mean" in their header to numeric data type and continuous modeling type. I'm getting the error that "Send Expects Scriptible Object" regarding the last line "cols << data type("numeric")". How would I fix my code? Or is there an easier way to accomplish the same task? cols = dt << get column names( string ); For( i = N Items( co...
Mcc99

Discussions |
Sep 2, 2024 2:45 PM

562 views | 2 replies
Graph builder: issue with multiple response

Since Jmp 17, Graph Builder can interprete columns with modeling type Multiple Response in a way that the entries are split and the values show up one by one. Amazingly useful!!

But there seems to be an issue if the column is used in different drop zones.
If the user wants to find out which of the students play multiple sports , the result looks boring:
there is just a diagonal line

Seems that Jmp sp...
hogi

Discussions |
Sep 2, 2024 1:36 PM

1561 views | 6 replies
Using Excel Wizard to Import Column Headings of Merged Cells

I have a spreadsheet with multiple analytes formatted as the example below. The analyte identification is two merged cells, and below is the well # and the final concentration. When importing I need the column names to be "Analyte - Well" and "Analyte - Final", but it's just showing as "Analyte - Well" and "Final". How do I get the merged heading to show on the second column as well? I thought " R...
Mcc99

Discussions |
Sep 2, 2024 12:55 PM

1026 views | 5 replies
P value

Bonjour, je suis noovice sur JMP et j'aimerais comprendre Pourquoi JMP ne donne pas de p-value pour certaines distributions comme une loi normale d'ordre 2 ou 3?

Merci
kowa

Discussions |
Sep 2, 2024 9:13 AM

664 views | 3 replies

Previous
Next

Latest Discussions

[JSL] Select rows using "Complex" conditions

Hello All, I would like to write a JSL script to select the rows in a table with “complex” conditions:I need to select ONE ROW per Metric (Column :Metric) with conditions IN ORDER OF PRIORITY: 1- if the condition Flag1 = “FLAG” AND Flag2 = “FLAG” exists, Select Col Max (:Metric1) of this condition2- if the condition Flag1 = “FLAG” XOR Flag2 = “FLAG” exists, Select Col Max (:Metric1) of this condit...
Voizingu

Discussions |
Sep 2, 2024 10:12 PM

973 views | 6 replies
Graph builder: issue with multiple response

Since Jmp 17, Graph Builder can interprete columns with modeling type Multiple Response in a way that the entries are split and the values show up one by one. Amazingly useful!!

But there seems to be an issue if the column is used in different drop zones.
If the user wants to find out which of the students play multiple sports , the result looks boring:
there is just a diagonal line

Seems that Jmp sp...
hogi

Discussions |
Sep 2, 2024 1:36 PM

1561 views | 6 replies
P value

Bonjour, je suis noovice sur JMP et j'aimerais comprendre Pourquoi JMP ne donne pas de p-value pour certaines distributions comme une loi normale d'ordre 2 ou 3?

Merci
kowa

Discussions |
Sep 2, 2024 9:13 AM

664 views | 3 replies
Task to build PAT rule by JMP

Hi Team, I am asking this is because we are going to implement dynamic PAT (part average testing) to the new product.Here is the idea temporarily. 1. Load the data table to JMP . Idenity the item we want to show +/- 6 sigma by JSL. Which funciton / plot is suitable from JMP if I would like to rule out coordinate out of +/-6 sigma? 2. One the JMP rule of the coordinate, how can I out the coordi...
Lichun

Discussions |
Sep 2, 2024 8:59 AM

2063 views | 4 replies
saved script format new table correctly, but no data is loaded

Hi all, JMP 18.0.1 in Windows Super beginner here. I'm trying to use scripts in order to save time formatting and analyzing data. I save a script from a dataset A via "red triangle > copy table script" and dump it in a text editor. Then I open the dataset B (exactly same original formatting as dataset A) and go "red triangle > new script", and paste the table script. The result is that I get a the...
lgutierrez

Discussions |
Sep 2, 2024 7:57 AM

564 views | 3 replies

Previous
Next

Latest Discussions

Flame graphs

Out of curiosity, has anyone ever managed to create something like a flame graph ( https://www.brendangregg.com/flamegraphs.html ) using Graph Builder? It looks like it would be ideal for analyzing hierarchical data, e.g. using the output of a linux "find . -ls" command to visualize disk usage.
BHarris

Discussions |
Aug 30, 2024 2:07 PM

363 views | 0 replies
AlT two factors with example fail

Could you provided me some example, file,with example of ALT, two faftors, for example temerature and humidity. Please
Juancho97

Discussions |
Aug 25, 2024 12:16 PM

328 views | 0 replies
Machine data source list remove in "Database Operations"

I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean
Sean_ShCn0

Discussions |
Aug 22, 2024 7:24 AM

474 views | 0 replies
Write Data from Data Table to Database

Hello JMP-Community,I am searching your help here because I didn't found a sufficent solution for myself in other posts. It is about writing content of a data table into a table of a database.For that I wrote this little function: myInsertInto = function({dt, dbConnection, destinationName}, cols = dt << GetColumnNames(String); rows = dt << Select All Rows << GetSelectedRows; show(cols, rows);...
DBo_94

Discussions |
Aug 22, 2024 6:38 AM

336 views | 0 replies
Is there a way to tell LCA that the rows are ordered by class?

Typical dataset: 120-200 rows, 15 classes. Rows are known to be ordered by class. What is unknown is where the 'fences' between classes are. As-is -- i.e., without taking row order into account -- LCA correctly classifies about 94% of rows. My intuition is that if I knew how to tell the algorithm that the rows are grouped by class on input, we'd be at 100%. Visual, in case my use of 'grouped by' i...
mtowle419

Discussions |
Aug 15, 2024 5:03 PM

347 views | 0 replies