JMP User Community

Latest Discussions

Group values from selected rows

Hi, I am trying to group values from the selected rows
Here is the dt: The final output should look something like this. So combine the Product values with similar percent. Any suggestion? dt = Current Data Table(); dt << select duplicate rows( Match( :Label, :Percent ) ); Try( dt<< delete rows );
Jackie_

Discussions |
May 26, 2024 11:24 PM

1854 views | 4 replies
Assign values containing in the list

Hi, this problem really puzzles me. I want to assign values from table 1 (dt_group) to table 2 (dt_subset). So iterate through each row of Table 2 and then compare the rows of the table 2 Product column with each row of table 1 ProductGroups and then assign the Limits values to the _LIMITS column in table 1 if matching sting is found. How would I script this?table 1:table 2: I already tried and ha...
Jackie_

Discussions |
May 26, 2024 2:47 PM

2013 views | 5 replies
Confusion with For Each resolving the value variable

In solving Iteratively create columns containing formulae I ran across a need to structure the solution in a way that I do not understand why. My initial solution was Names Default To Here( 1 ); dt = // Open Data Table: semiconductor capability.jmp // → Data Table( "semiconductor capability" ) Open( "$SAMPLE_DATA/semiconductor capability.jmp" ); colNames = dt << get column names( continuous, st...
txnelson

Discussions |
May 26, 2024 8:43 AM

1232 views | 1 replies
SVEM: ¿Neural network or Lasso?

I am conducting a prediction model study with DoE mixtures (3 components) and a process factor and a response variable (quantitative). I am going to apply SVEM, but I have a question, what does it depend on when using Neural Networks or Lasso? Thank you for your answers.
CrhistianDoE

Discussions |
May 25, 2024 2:27 AM

1616 views | 1 replies
Automatically plot associated columns

I have a data table containing voltage values associated with a structure of a particular size. I also have a column describing the current resulting from the applied voltage for the same structure size. When there are a large quantity of such columns, is there a way to have the columns that are related be plotted without any of the other unassociated plots being generated as a result? I can of...
SpannerHead

Discussions |
May 24, 2024 7:30 AM

1916 views | 4 replies

Previous
Next

Latest Discussions

SVEM: ¿Neural network or Lasso?

I am conducting a prediction model study with DoE mixtures (3 components) and a process factor and a response variable (quantitative). I am going to apply SVEM, but I have a question, what does it depend on when using Neural Networks or Lasso? Thank you for your answers.
CrhistianDoE

Discussions |
May 25, 2024 2:27 AM

1616 views | 1 replies
JSL Script using Python not working anymore in JMP 18

We are in the process of porting our toolchain into JMP 18. Since many of the JMP python calls have been deprecated/changed in JMP 18 and we are using elements of python, I'm trying to troubleshoot some scripts of ours that are working fine in JMP 17 but are throwing errors when I run them on JMP18.The problem solving in the forum here is a bit difficult since I cannot share the exact content of ...
Feli

Discussions |
May 23, 2024 6:53 AM

1551 views | 2 replies
Compare values

Hi, here is an example of a list Here is the final result I would like to achieve: Thanks,
Jackie_

Discussions |
May 22, 2024 8:59 AM

3843 views | 9 replies
Is there a quick way to transform column data type?

I have a question for help, thanks.
There is a table with more than 1200 columns, since many data values starting with “i”, there are about 900 columns, so I need to convert the column format from character to numeric, but with a for loop, it's too slow, is there a fast way?
lehaofeng

Discussions |
May 21, 2024 11:04 PM

2682 views | 7 replies
Scheduler Generates Dissociation Error when script is refreshed after timer.

I'm very new to jmp Scripting and working on making a script that my team can use during processing that will refresh so they can monitor the process as they work without having to interact too much with their computer. I got the refresh working but when the scheduler timer runs out and the script runs again, I am getting an Error message stating: The source table has changed. The summary table w...
CriticalSeries2

Discussions |
May 21, 2024 1:52 PM

805 views | 1 replies

Previous
Next

Latest Discussions

graph builder bug - x group shift

(JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...
ShlomiB76

Discussions |
Apr 14, 2024 12:08 AM

720 views | 0 replies
Project ignoring H Splitter Box Set Sizes . . . sometimes

I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...
ionatx

Discussions |
Apr 4, 2024 1:25 PM

710 views | 0 replies
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

663 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