JMP User Community

Latest Discussions

How to stack several columns into a new column ignoring duplicate entries?

I have multi column (character, nominal) data table. I want to get the the entries/items in the last four columns into a new column in the same data table ignoring duplicate entries/items from the columns being stacked. How to achieve this in JSL?
Neo

Discussions |
Sep 13, 2023 12:11 PM

3468 views | 7 replies
Rerun Transfrom Column

To reevaluate the Formula of a Formula column, one can writecol<<Eval Formula()Is there a similar command to re-evaluate a Transform Column?

Eval Formula doesn't seem to work here - Tcol1 still shows a curve with ::scalingFactor=1: Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); gb = dt << graph builder(); ::scalingFactor= 1; tC = dt << transform column ("TCol1",Formula( :heig...
hogi

Discussions |
Sep 13, 2023 4:51 AM

1677 views | 4 replies
JSL alternating row legend for multiple variability charts in one window

Hi all, I'm stuck with a scenario. I have a variability graph that has 8 different graphs in one window by using the by clause twice. One case has two options and I want to add a row legend with for one column for one case and another for the other as one has the value colors set differently for one case. Below is the JSL code that I am attempting but is not working to even display the row legen...
neelsrejan

Discussions |
Sep 13, 2023 12:29 AM

1503 views | 1 replies
Exporting Graphs from Tab box to Excel cell

Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"}; List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"}; List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"}; List4 = {"SN...
Jackie_

Discussions |
Sep 12, 2023 2:09 PM

824 views | 0 replies
JSL to generate matching column difference and average

Hello,I am hoping to get some help on the following:Attached JMP file with the following table.My typical/starting data set contain:1. an identifier "Type"2. a set of unknown number of columns with same prefix and various number suffix, e.g. A num1, A num2, A num3...3. a second set of the same number of columns as in #2 above, with same prefix and matching suffix as in #2, e.g. B num1, B num2, B n...
pkl_jmp

Discussions |
Sep 12, 2023 12:14 PM

3387 views | 8 replies

Previous
Next

Latest Discussions

Rerun Transfrom Column

To reevaluate the Formula of a Formula column, one can writecol<<Eval Formula()Is there a similar command to re-evaluate a Transform Column?

Eval Formula doesn't seem to work here - Tcol1 still shows a curve with ::scalingFactor=1: Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); gb = dt << graph builder(); ::scalingFactor= 1; tC = dt << transform column ("TCol1",Formula( :heig...
hogi

Discussions |
Sep 13, 2023 4:51 AM

1677 views | 4 replies
Exporting Graphs from Tab box to Excel cell

Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"}; List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"}; List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"}; List4 = {"SN...
Jackie_

Discussions |
Sep 12, 2023 2:09 PM

824 views | 0 replies
How Formula works in New Column Function

dt = Open( "$SAMPLE_DATA\Big Class.jmp" ); New Column("Sum", "Numeric", "Continuous", Set Formula(If(Row() == 1, :Height, Lag(:Sum,1) + :Height)) ); The code above creates Sum column with calculated the accumulative sum. I am new to JSL so could someone explain me how the Formula command works. Is it scan one by one row in the column so that we can write :Height instead of constructing a For-loop ...
hmm

Discussions |
Sep 12, 2023 4:33 AM

1220 views | 1 replies
Formula and graphbuilder

Dear Community, I need your help and I would like to apologize if it is a stupid question. I’m struggling with the graphbuilder.I would like to use a column including a formula option for plotting it in the graphbuilder window.Nevertheless, it only works when all the parameters are included in the formula (the two following pictures). When I try to make my formula “flexible” with a link to other c...
BigShaftie

Discussions |
Sep 12, 2023 3:04 AM

2089 views | 4 replies
To automate the Mulitple Data table selection while running Add-Ins.

Dear All,I am facing a small challenge to implement the Dashboard via Add-Ins. I have a JMP script to import the test data into different Data Table and to make plots for them. I have succeeded in creating an Adds-Ins to create a Dashboard out of the Plots from different Data Tables, however as it involves many Data Table it prompts a menu to select the corresponding Data table to create the Dashb...
SSMann03

Discussions |
Sep 11, 2023 7:47 AM

3040 views | 2 replies

Previous
Next

Latest Discussions

Exporting Graphs from Tab box to Excel cell

Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"}; List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"}; List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"}; List4 = {"SN...
Jackie_

Discussions |
Sep 12, 2023 2:09 PM

824 views | 0 replies
PickFile() from within a Project does not use file filters

When I use PickFile() outside of a project, it works as noted in the scripting guide, scripting index, and other posts here in the forums. However, when I run the script within a project, the window that opens is a different one. It seems to be in order to allow you to pick a file that is saved to the project itself, but the filters do not work even though it shows the folder that I specified as d...
R2OKeefe

Discussions |
Sep 3, 2023 8:45 PM

1204 views | 0 replies
Robust Fit Outliers - different row set selected and excluded as outliers

Dear community,I have a stacked data table, and want to exclude outliers by a Label (e.g. an element for some measurements).In the robust fit outlier platform I can detect outliers and than can select or exclude corresponding rows.For my understanding, rows that are selected than or excluded, should be exactly the same ones.And that is the case for the below sample data table used in the JSL below...
Georg

Discussions |
Aug 16, 2023 2:40 AM

1001 views | 0 replies
Get the JMP Default Dark color theme

Hello, Is there anyway I could extract all the color codes used in these color themes, using JSL or any another way?I do have difficulties in dealing with colors, hence I rely more on HEX codes, or numeric codes. Thank you.
Kenobi

Discussions |
Aug 9, 2023 9:26 AM

1296 views | 0 replies
How to use JSL of JMP software to find the one that is more suitable for sinusoidal curve from multiple sets of data?

Hello!For example, using large class data:
Compare the height column and the weight column to see which column fits the sinusoidal distribution better.
The parameters of the sine curve are random. Thanks!
UersK

Discussions |
Jul 24, 2023 11:44 PM

804 views | 0 replies