JMP User Community

Latest Discussions

Possible to preserve leading white space in column names for copied table scripts?

Problem: I run a script to load data from a database. I delete all formulas from the data table. I copy the table script using the red triangle menu. I paste the table script into a script window. I run the script. The table resulting from the table script has different column grouping and throws the columns around (see screenshot showing Columns panel from original table and table as created by t...
Ressel

Discussions |
Oct 28, 2022 9:31 AM

1839 views | 3 replies
How can I add reference line in distribution for histograms without coding ?
dheerules

Discussions |
Oct 28, 2022 9:30 AM

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

1437 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

4310 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

12976 views | 10 replies

Previous
Next

Latest Discussions

How can I add reference line in distribution for histograms without coding ?
dheerules

Discussions |
Oct 28, 2022 9:30 AM

1216 views | 2 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

4310 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

1692 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

2416 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

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

722 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

763 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

679 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

1824 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

578 views | 0 replies