JMP User Community

Latest Discussions

Is this possible to write a script that opens always the last sheet of an xlsx file?

I need a JSL script that opens always the last sheet of a chosen xlsx file. Is there a function to do this in JSL?
Alternatively, is it possible to accomplish this by compiling all the sheets of the Excel file into a list and open the last item of the list? Or open the excel file in a way that the user can input the sheet to open?
jlmbs

Discussions |
Nov 2, 2022 12:53 AM

2913 views | 5 replies
JMP 17 Trial - windows server not supported

Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas? Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.
ron_horne

Discussions |
Nov 1, 2022 2:20 PM

1418 views | 0 replies
Number edit box not updating column

I am trying to update a column with a formula given a text edit box input. I have attempted other solutions found on the discussions page but with no luck In the beginning of my code I define the area as 1 as a default. This is also the default value inside of the number edit box: area = 1; I have a column that uses the area variable: dt << New Column( "Current Density", Numeric, "Continuous",...
trevorphysics

Discussions |
Nov 1, 2022 1:46 PM

1631 views | 2 replies
How to hover over a point and see the image associated with that row

Hi. I have a column in a table with URL links to images. I would like to hover over a point and see the image associated with that row. And also click the point and go to the URL. Any help would be much appreciated.
SampleTapir814

Discussions |
Nov 1, 2022 12:24 PM

2533 views | 2 replies
Select Rows Based on Another Summary Data Table Each Row of Multiple Column Values

Hi,I am facing issue to write a code to select rows based on another summary data table each row of multiple column values. The summary data table is variable, change from time to time.Below is JSL code. It does not work as required. I need help here. Example,In summary data table,row#1, Make = Acura, Model =Integra, Protection = manual belts, base on these values select rows in Data Table A.row#2...
Lino

Discussions |
Nov 1, 2022 8:52 AM

3426 views | 5 replies

Previous
Next

Latest Discussions

JMP 17 Trial - windows server not supported

Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas? Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.
ron_horne

Discussions |
Nov 1, 2022 2:20 PM

1418 views | 0 replies
How to hover over a point and see the image associated with that row

Hi. I have a column in a table with URL links to images. I would like to hover over a point and see the image associated with that row. And also click the point and go to the URL. Any help would be much appreciated.
SampleTapir814

Discussions |
Nov 1, 2022 12:24 PM

2533 views | 2 replies
Questions about "Multi HTTP Request" of JMP17?

Hello!JMP17 added "Multi HTTP Request"
Sample code: Do the three download tasks download at the same time, or do the next tasks download when one is complete?
Will the overall download time be reduced by using this feature?urls = {"http://cdimage.ubuntu.com/lubuntu/releases/20.04.3/release/lubuntu-20.04.3-desktop-amd64.iso", "http://downloads.sourceforge.net/clonezilla/clonezilla-live-2.7.3-19-amd64...
lala

Discussions |
Nov 1, 2022 6:52 AM

3099 views | 5 replies
How to assign a data table reference to table opened by jmpquery?

Is there a way in JSL to assign a table created from a jmpquery execution?Instead of:dtBigClass = open("BigClass.jmp");I would like to assign "dtBigClass" to a jmpquery that I just executed. Many thanks, John
JohnDMoore1

Discussions |
Nov 1, 2022 12:16 AM

1633 views | 2 replies
PER file location does not exist

Every time I log into JMP I get a pop up that says "The PER file location does not exist, please enter an existing location." I've tried re-associating the license file without success. Any ideas?
aq

Discussions |
Oct 31, 2022 10:08 PM

3445 views | 4 replies

Previous
Next

Latest Discussions

JMP 17 Trial - windows server not supported

Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas? Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.
ron_horne

Discussions |
Nov 1, 2022 2:20 PM

1418 views | 0 replies
How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...
SquaresDingo505

Discussions |
Oct 24, 2022 7:23 PM

879 views | 0 replies
How to Analyze and Graph Responses with Supercategories

I use JMP Pro 16. I am doing MCA on 90 columns that have supercategories. I want to do the analysis and viz on the supercategory classification. Is there a way to do this without having to create separate columns that only have the supercategory classification? PS: I don't know how to do JSL scripting.
TCM

Discussions |
Oct 21, 2022 5:59 AM

943 views | 0 replies
標準化列名稱如何用變數取代求解

//新增周標準化
weekEMC_HF_C_12_0 = Data Table( "周_EMC_HF_C_12um" ) << Get Column Names( string );
weekEMC_HF_C_12 = {};
//少一周={:"2022W38"n,:"2022W40"n,:"2022W41"n};
For( j = N Items( weekEMC_HF_C_12_0 ), j >= (N Items( weekEMC_HF_C_12_0 ) - 5), j--,
Insert Into( weekEMC_HF_C_12, weekEMC_HF_C_12_0[j] )
);
Try(
Local( {old dt = Current Data Table()},
Current Data Table( Data Table( "周_EMC_HF_C_12um" ) );
For Each( ...
Ken697

Discussions |
Oct 20, 2022 9:22 PM

843 views | 0 replies
Methods for compressing a CSV or TSV file with jmp compression to save as .jmp table without having to open the csv in JSL first?

I have access to both JMP12 and JMP14, so a solution for either would work. What I am trying to achieve is saving very large text files (csv,tab,tsv,etc.) with JMP compression such that I get a compressed .jmp file as the result. By large I mean 2-6gb files. Currently I use something like this: MyDataFile = open(filename,Private); MyDataFile << Compress File When Saved; MyDataFile << save(filetosa...
CurbStegosaurus

Discussions |
Oct 14, 2022 9:06 AM

2191 views | 0 replies