JMP User Community

Latest Discussions

Axis sort giving odd result

I tried to sort the X-Axis by descending values.. but it's clearly not doing that. What am I missing? INV$ is the Y-axis. I want most INV$ to least by label on the X-axis.
Phil_Nash

Discussions |
Oct 31, 2022 6:25 AM

1620 views | 4 replies
Scripting: save multiple data table to multiple sheets in Excel

I like to save multiple datatables, each to an individual sheet, in a single Excel file?What is the script to achieved that? I tried "append", but it did not workdt<< Save as("$DESKTOP/Untitled73.xlsx", append); Thanks!
GroupSquareWolf

Discussions |
Oct 30, 2022 10:35 PM

2167 views | 4 replies
How to close multiple images loaded after obtain the data table using JSL

Hi, I'm analyzing 6 images using JMP with script by converting the images into data table.I've concatenated all the images values into 1 data table. The issue is, I can close the previous image data table with Close( Data Table( Tables[i] ), No Save );But I can't close the 6 images.I tried something like Close(img) or Close("image") but it won't close. Any idea how to close the images in script? N...
WebDesignesCrow

Discussions |
Oct 30, 2022 6:20 PM

1460 views | 3 replies
Got extra columns after open CSV file in JMP

Hi all,

Problem statement:
JMP table displays extra columns compared with the number of column of input file.Detail:I have some input files (.csv) which has only one column. However, when I load these files into JMP, JMP table displays 2 more columns. Lets take a look to image below I believe that all csv files that I got are originally .XML files.
Is there any possibility that I can load .csv file...
PhamBao

Discussions |
Oct 30, 2022 4:52 PM

1307 views | 3 replies
how to replace / insert character into double quote of a string

Dear all, I have a string like this .<ak:Unit X="0" Y="1" Id="U33"> Do you know how to replace characters in double quotes of a string For example <ak:Unit X="0" Y="1" Id="U33"> ==> <ak:Unit X="Default1" Y="Default2" Id="Default3"> Sincerely
PhamBao

Discussions |
Oct 30, 2022 3:10 PM

2460 views | 7 replies

Previous
Next

Latest Discussions

Got extra columns after open CSV file in JMP

Hi all,

Problem statement:
JMP table displays extra columns compared with the number of column of input file.Detail:I have some input files (.csv) which has only one column. However, when I load these files into JMP, JMP table displays 2 more columns. Lets take a look to image below I believe that all csv files that I got are originally .XML files.
Is there any possibility that I can load .csv file...
PhamBao

Discussions |
Oct 30, 2022 4:52 PM

1307 views | 3 replies
how to replace / insert character into double quote of a string

Dear all, I have a string like this .<ak:Unit X="0" Y="1" Id="U33"> Do you know how to replace characters in double quotes of a string For example <ak:Unit X="0" Y="1" Id="U33"> ==> <ak:Unit X="Default1" Y="Default2" Id="Default3"> Sincerely
PhamBao

Discussions |
Oct 30, 2022 3:10 PM

2460 views | 7 replies
Arabic Language

Hello everyone,i want to apply text analytics on an Arabic dataset using JMP how can i do that ?i already tried the tokenization it but it does not work, it does not recognize Arabic language
Jamesrodry

Discussions |
Oct 29, 2022 7:48 AM

990 views | 1 replies
how to have a mixture response surface design

I am using JMP 15. From classical > there is either mixture design or response surface design. From custom design I can select mixture factors, however, there is no option of response surface design. I am wondering how can I have a response surface design for mixture? Thanks
loganshawn

Discussions |
Oct 29, 2022 2:07 AM

4249 views | 6 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

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

737 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

778 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

698 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

1858 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

591 views | 0 replies