JMP User Community

Latest Discussions

How can use JSL to automatically add code to "Event Handler" in "Properties" of a specified column?

Big Class.jmpThanks!Function( {thisTable, thisColumn, iRow}, {}, n1rows = thisTable << Get Rows Where( :n1 == thisTable:thisColumn[iRow] ); n2rows = thisTable << Get Rows Where( :n2 == thisTable:thisColumn[iRow] ); thisTable << Select Columns( {thisColumn, :n1, :n2} ) << Clear Cell Colors; thisColumn << Color Cells( {3, {iRow}} ); :n1 << Color Cells( {3, n1rows} ); :n2 << Color Cells( {3, n...
lala

Discussions |
Sep 15, 2023 7:33 AM

1479 views | 2 replies
What is the JSL equivalent of Cols>> Column Names>>Move Up ?

For an open data table, what is the JSL equivalent to Cols>> Column Names>>Move Up ?(cannot see the script in the log when I do this interactively)I need to make the first row of my data table as header (via JSL). I am on JMP 16.
Neo

Discussions |
Sep 15, 2023 1:50 AM

2602 views | 5 replies
Simpler way to save a new script to data table

(1) I compose a script in a new script window by 'save to script window' for a number of actions, e.g. filtering, plotting etc. This window is not connected to the data table, yet.(2) To save the script I go to the data table, open a new script, give it a name, copy paste content from the other script window and then save. Is there a simple way to save the script to the data table without first h...
Ake

Discussions |
Sep 14, 2023 6:15 AM

1239 views | 1 replies
Rename columns contains certain symbol

Hello dear users/experts, I have a table has many columns, where some of the columns are started with "std" (some are not),for example column names could be:std_A, std_AX, med_XA,data_Ex,std_BN.... And i would like to change to A_std, AX_std, med_XA, data_EX, BN_std... only remove std at the begining of column names and put them in the end with _
MarkovRootFox46

Discussions |
Sep 14, 2023 1:40 AM

933 views | 1 replies
How to save dashboard as interactive html

I have a script that generates a dashboard. I need a code string to take the open dashboard and save it as interactive HTML. I have found the following code to do partly the same (original source), but I am unsure how to modify it to work with an already open dashboard. Names Default To Here( 1 ); tmp_path = Substitute( Right( Convert File Path( "$TEMP" ), Length( Convert File Path( "$TEMP" ) ) -...
Steffen_Bugge

Discussions |
Sep 14, 2023 1:28 AM

1775 views | 2 replies

Previous
Next

Latest Discussions

Simpler way to save a new script to data table

(1) I compose a script in a new script window by 'save to script window' for a number of actions, e.g. filtering, plotting etc. This window is not connected to the data table, yet.(2) To save the script I go to the data table, open a new script, give it a name, copy paste content from the other script window and then save. Is there a simple way to save the script to the data table without first h...
Ake

Discussions |
Sep 14, 2023 6:15 AM

1239 views | 1 replies
Rename columns contains certain symbol

Hello dear users/experts, I have a table has many columns, where some of the columns are started with "std" (some are not),for example column names could be:std_A, std_AX, med_XA,data_Ex,std_BN.... And i would like to change to A_std, AX_std, med_XA, data_EX, BN_std... only remove std at the begining of column names and put them in the end with _
MarkovRootFox46

Discussions |
Sep 14, 2023 1:40 AM

933 views | 1 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

1676 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

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