JMP User Community

Latest Discussions

Substring of a file name column between uknown number of characters

When i input data I end up with a file name column that looks like this: File NameTest Name Date ID# Wafer and Device ID1 #ID commentTest Name Date ID# Wafer and Device ID2 #ID different commentDifferent Test Name Date ID# Wafer and Device ID1 #ID commentDifferent Test Name Date ID# Wafer and Device ID2 #ID different comment What I want is the following: File NameWafer and Device ID1Wafer and Devi...
trevorphysics

Discussions |
Nov 3, 2022 6:43 AM

1607 views | 4 replies
Bookmarks?

OK, so I bookmarked some of the posters and presentations for the most recent Discovery conference so I could come back and review them in more detail, but I find no way to find my bookmarks? Can anyone share how to find one's bookmarks? Thanks.
sfigard

Discussions |
Nov 2, 2022 2:10 PM

883 views | 2 replies
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

781 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

17267 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

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

781 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

2034 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

934 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

1533 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

1858 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

934 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

537 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

583 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

557 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

1381 views | 0 replies