JMP User Community

Latest Discussions

How to rename column 1 for every file during multiple file import

Hi guys, I wish to rename the first column of every file so that all files can be imported to one single file.Would anyone be able to help please? Multiple File Import( <<Set Folder( "C:\Work folder\" ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Set Name Filter( "*.*;" ), <<Set Name Enable( 0 ), <<Set Size Filter( {50795737, 79592416} ), <<Set Size Enable( 0 ), <<Set Date Filter( {3...
Hellford

Discussions |
Nov 2, 2022 1:56 PM

1296 views | 2 replies
How to convert Python Pandas dataFrame to jmp format without saving it as files?

I know JMP support "Python Interface" function within JMP script envirornment. But somtimes it will be better to do co-work independently Python engineer and JMP one. In our case, Python engineer read database files with DB interface, and makes pre-process with Pandas library, and wants to convert JMP format because JMP enginner need only JMP format data in order to do data analysis and post-proce...
Kwangki

Discussions |
Nov 2, 2022 12:55 PM

20616 views | 11 replies
Heat Map / Aggregate Function

I wondered if anyone can point me in the right direction. I have a script that creates a table with Row, Column and Data fields (multiple Data field values for each (Row,Column) pair). I'd like to be able to create a Heat Map showing the Range for each Row and Column pair. By default the Mean is plotted. I can create an aggregated field (sum, median, std deviation and some others are included but ...
marktaylor

Discussions |
Nov 2, 2022 8:50 AM

2808 views | 3 replies
Loop function in Slider box

Hi,
I want to add ref line to several axis box and vary the reference line with slider box. I am wondering if loop can be used?

Here's my code:- I was able to add reference line to each of the charts but the issue I face is when I vary the slider box, the loop functions takes a while to add a reference line and it's glitchy. Any other alternate way to implement? I appreciate if you could advice. Th...
Jackie_

Discussions |
Nov 2, 2022 5:38 AM

2101 views | 3 replies
remove subplot titles

I want to get rid of subplot titles to get more space for the plots. Hm, GraphBuilderGroupBoxes - quite uncooperative, as mentioned before :)
https://community.jmp.com/t5/Discussions/Identifying-Titles-of-Graph-Builder-Page-Titles/m-p/426380/highlight/true#M67622
https://community.jmp.com/t5/Discussions/GraphBuilderGroupBox-lt-lt-Get-Window-Title-issue/m-p/423554 Seems that just the collapse and del...
hogi

Discussions |
Nov 2, 2022 3:39 AM

3343 views | 4 replies

Previous
Next

Latest Discussions

How to rename column 1 for every file during multiple file import

Hi guys, I wish to rename the first column of every file so that all files can be imported to one single file.Would anyone be able to help please? Multiple File Import( <<Set Folder( "C:\Work folder\" ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Set Name Filter( "*.*;" ), <<Set Name Enable( 0 ), <<Set Size Filter( {50795737, 79592416} ), <<Set Size Enable( 0 ), <<Set Date Filter( {3...
Hellford

Discussions |
Nov 2, 2022 1:56 PM

1296 views | 2 replies
Heat Map / Aggregate Function

I wondered if anyone can point me in the right direction. I have a script that creates a table with Row, Column and Data fields (multiple Data field values for each (Row,Column) pair). I'd like to be able to create a Heat Map showing the Range for each Row and Column pair. By default the Mean is plotted. I can create an aggregated field (sum, median, std deviation and some others are included but ...
marktaylor

Discussions |
Nov 2, 2022 8:50 AM

2808 views | 3 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
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

2530 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

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

2190 views | 0 replies