JMP User Community

Latest Discussions

Value Label

I'm trying to change values in multiple columns using a For loop and an If statement. unfortunately, while it creates the new columns properly, the values in the second column are for some reason copied into the first column as well. What am I missing?New Table( "Untitled 11", Add Rows( 4 ), New Column( "Column_1", Character, "Nominal", Set Values( {"A1000", "A2000", "A3000", "A4000"} )...
Algerine

Discussions |
Oct 28, 2022 10:46 AM

1378 views | 2 replies
Color by column in multiple dashboards

Hi, I am trying to create a tabbed dashboard from the same data table, each tab is for a particular tool type. I would like to like to color the plots in each tab by that particuar tool type using "color by column". However, once the second tab uses the color by column, the previous tab's color scheme changes. Is there any way to prevent this so that the coloring scheme is for previous tab is not ...
SM1956

Discussions |
Oct 28, 2022 9:34 AM

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

Previous
Next

Latest Discussions

Color by column in multiple dashboards

Hi, I am trying to create a tabbed dashboard from the same data table, each tab is for a particular tool type. I would like to like to color the plots in each tab by that particuar tool type using "color by column". However, once the second tab uses the color by column, the previous tab's color scheme changes. Is there any way to prevent this so that the coloring scheme is for previous tab is not ...
SM1956

Discussions |
Oct 28, 2022 9:34 AM

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

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