JMP User Community

Latest Discussions

Scripting : Multiple tables from Excel

Writing a script to open Excel files that contain multiple sheets then do independent analysis with each individual sheet. The names and number of sheets from different Excel files can be different, so would like to write a generic code that can work on different files. Used Open command to open the file dt = Open ("file path"); This particular example file has three sheets, so show (dt); giv...
GroupSquareWolf

Discussions |
Oct 28, 2022 7:45 AM

1440 views | 1 replies
How do i get the list box to work?

I am new to JMP and I came across the List Box which allows us to filter data based on the selection, but it is currently not working for me. I am getting the list box to display, but it doesn't change anything in the graph. I would expect the time to change based on arrival or departure.Any suggestions? dt = Open("$sample_data/Air Traffic.jmp"); m_name = dt:Event << get values << As List(m_name...
AbbWorld27

Discussions |
Oct 28, 2022 3:39 AM

4331 views | 6 replies
Importing Spec Limits

So I have a script that runs Process Capability on a table of data. I am able to run it automatically using this solution, https://community.jmp.com/t5/Discussions/JSL-automate-the-columns-used-in-Process-Capability/m-p/39855. I am now trying to import the spec sheet automatically too. Right now users automatically have 2 sheets. 1 with data and 1 with the spec info. I can make a solution that tak...
jay_S

Discussions |
Oct 28, 2022 2:48 AM

12992 views | 10 replies
Graphing a radial spec limit on an XY scatter plot

Hello -Many processes that require alignment use the standard GDT circular position tolerance instead of a rectangular tolerance. So we will frequently have alignment tolerances that are, for example, a 100 micron radius and not +/-100 microns. The best way to look at this data is an XY scatter plot with a radial spec limit. Instead of a spec limit square with a separate X and Y spec, you have a ...
jay_holavarri

Discussions |
Oct 28, 2022 1:16 AM

1695 views | 2 replies
How do I import .txt file with several rows of column header

How do I import .txt file with several rows of column header? There is no selection in txt import window to select multiple rows as column header similar to Excel Import Wizard So, what I did was.Import text as JMP table. Save the JMP table as xlsx. fileImport the xlsx. file by using Excel Import Wizard and specify how many rows we need for the column header Is there any other way? dT = current d...
Nita_Natchanok

Discussions |
Oct 28, 2022 12:34 AM

1515 views | 1 replies

Previous
Next

Latest Discussions

How do i get the list box to work?

I am new to JMP and I came across the List Box which allows us to filter data based on the selection, but it is currently not working for me. I am getting the list box to display, but it doesn't change anything in the graph. I would expect the time to change based on arrival or departure.Any suggestions? dt = Open("$sample_data/Air Traffic.jmp"); m_name = dt:Event << get values << As List(m_name...
AbbWorld27

Discussions |
Oct 28, 2022 3:39 AM

4331 views | 6 replies
Graphing a radial spec limit on an XY scatter plot

Hello -Many processes that require alignment use the standard GDT circular position tolerance instead of a rectangular tolerance. So we will frequently have alignment tolerances that are, for example, a 100 micron radius and not +/-100 microns. The best way to look at this data is an XY scatter plot with a radial spec limit. Instead of a spec limit square with a separate X and Y spec, you have a ...
jay_holavarri

Discussions |
Oct 28, 2022 1:16 AM

1695 views | 2 replies
how to paste empty cell as empty cell

Hi, I want to copy a column with some empty cells and numbers to another new column. But when I pasted it, the empty cells are turn into 0. I cannot delete it one by one because there are many of them. How can I keep the pasted empty cell as it was? Thank you
Danying

Discussions |
Oct 28, 2022 12:14 AM

2422 views | 4 replies
how to compare oscilloscope traces and detect outlier traces?

Hello, i am wondering if there is a way in JMP to compare oscilloscope voltage traces to tell whether the traces are statistically the same or different. the reason i want to know is bc i collect example scope traces to qualify power supplies. when i plot the traces they visually appear to line up quite well (both the waveform shape and voltage magnitudes), but of course the traces aren't identic...
LogitPorcupine1

Discussions |
Oct 27, 2022 2:29 PM

1869 views | 3 replies
Within sigma mismatch between IMR control chart & process screening platform

Hello, I am trying to plot control charts for various process parameters. My data is a monitoring data where I get one data point for each parameter every week. The parameter shown here is the std dev measurement from the monitor wafer. I am trying to plot these std dev. data points from multiple weeks into an IMR chart. I was trying to use JMP process screening platform to be able to short list a...
bharathu

Discussions |
Oct 27, 2022 11:38 AM

2694 views | 5 replies

Previous
Next

Latest Discussions

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

724 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

768 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

682 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

1834 views | 0 replies
Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

580 views | 0 replies