JMP User Community

Latest Discussions

How to get column number from column name? (JMP)

This may be a really simple question but after a lot of searching and testing I can't figure it out. How do I get the column number for a given column if all i know is the column name from a column dialog box?Minimized code:dlg = Column Dialog( dlg_firstParam = ColList( "First Parameter"));firstParam = dlg["dlg_firstParam"][1];i = 5; // this is a test case. Assume i am going to select the fifth ...
mikedriscoll

Discussions |
Jan 14, 2019 9:14 AM

16271 views | 3 replies
Concatenate Multiple tables with different column order

Team,I have 5 csv files each having 200column (not each file have same number of columns). Each file has columns in different order. I want to write a scirpt which will let user to select all 5 files then combine all 5 files (dropping mismatched columns) and save the combined csv file to the required location. I want to use command similar to (data = Open(Pick File("Choose the File", x)), x is the...
Rajat

Discussions |
Jan 14, 2019 8:11 AM

7490 views | 11 replies
Convert List to Matrix

What is the quickest way to convert a list: {"a", 1, 2, "b"} into a matrix: [. 1 2 .]? I expect that I can just loop through all of the elements, but I'm hoping there is a quicker way since I will be doing this many thousands of times in my application, with each list containing hundreds of elements.
MarkDayton

Discussions |
Jan 14, 2019 6:55 AM

16160 views | 9 replies
How to reference columns whose name begin with a number

I am looking to use the select where function within JSL script.However, it wont let me reference my column as it begins with a letter i.e 20GHz_timeI want to do :20GHz_time <1000 however it won't let me. I cant reference based on what column number it is as the columns can change from data table to data table so I need a way to capture it. What is happening is the :20 is getting highlighted in gr...
conroyco

Discussions |
Jan 14, 2019 4:07 AM

3589 views | 1 replies
how to fix graph size when add multiple graphs in single window?

Hello,I use For loop to create graph size (800,800) and add to the same window. When test the script only for one graph, size is correct. When added multiple graphs in single window, it will adjust y automatically and it is too narrow to review the data. Could you please advise how to fix graph size when add to the single window?Thank you. nw= New Window("Report"); For(j = 1, j <= nitems(mylist)...
Akane

Discussions |
Jan 14, 2019 12:52 AM

7041 views | 3 replies

Previous
Next

Latest Discussions

How to reference columns whose name begin with a number

I am looking to use the select where function within JSL script.However, it wont let me reference my column as it begins with a letter i.e 20GHz_timeI want to do :20GHz_time <1000 however it won't let me. I cant reference based on what column number it is as the columns can change from data table to data table so I need a way to capture it. What is happening is the :20 is getting highlighted in gr...
conroyco

Discussions |
Jan 14, 2019 4:07 AM

3589 views | 1 replies
Displaying output in a journal

I am using the following script to create a data report and finally save the result as html.The script plots a graph and a table to the right of the graph.Say graph1 and table1.I want to display table2 below table1. To create table2 I use tabulate function and then make into data table function. If I use the data box and append feature again, the table2 is displayed on the right of table1.But I ne...
ENTHU

Discussions |
Jan 10, 2019 6:47 PM

2872 views | 1 replies
Can I have a different local data filter for each column using the column switcher?

I am looking to use the column switcher, but each column needs a different local data filter. Is there a way to assign a specific local data filter to each column? I have attached a JMP file with the three separate graphs I want with their appropriate data filters, and would like to have one graph using the column swicher to cycle through each. (Column switcher for Temp, pH, and concentration.)
kk

Discussions |
Jan 10, 2019 12:18 PM

5207 views | 7 replies
Memory usage when creating many tables

When creating many tables and then closing them JMP seems to keep the tables or some remnants in memory. The memory is sometimes released after a while. I ran into this when simulating a measurement situation with noise sources. JMP din't crash but after RAM ran out windows started swapping to HDD. Below is the simplest example where I was able to repeat the problem. Question: is this expected beh...
Niko_Porjo

Discussions |
Jan 10, 2019 2:08 AM

6470 views | 4 replies
screen size

Hi,

I created a dashboard for an HP E 222 screen: I can see the data filter box and the complete graph of each tab page boxes. but ifI or my colleagues have a smaller screen (20 ") or notebook PC, we no longer have the full width of the dashboard. Is there a trick to adapt the dashboard to the size of the screen: with a jsl or other solution?

best regards
Françoise

Discussions |
Jan 9, 2019 7:58 AM

7724 views | 4 replies

Previous
Next

Latest Discussions

I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2412 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3110 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3437 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2327 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3278 views | 0 replies