Saving Data Table to Excel format
Hi,Is there any way to save a data table into Excel (.xlsx) format with scripting?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi,Is there any way to save a data table into Excel (.xlsx) format with scripting?
Hi,
May I know how to make the iteration for adding the reference line on chart by using JSL script?
Because now I only can add the reference line on the chart for the first tab, other tab of the chart are not able to generate out.
Anyone can help?
Thanks.
Hello everyone, I'm trying to iterate through multiple tables and replace any value >6 sigma with a ".". Below is my attempt to iterate through big class and replace the weight and height values greater than 1 sigma with a .; however, it is not working as intended. I think I'm confusing myself with the two strings. Names Default To Here( 1 );
Clear Globals();
dt = Open("...\SAS\JMP\13\Samples\...
I have a two questions regarding JSL and Dashboards. The dashboard script I am currently writing has multiple graphs and runs without issue. However, my problem lies in trying to save the file. I would like to be able to save the file as a TIFF. Therefore questions: 1) How do you save a Dashboard as an image?2) To save the Dashboard as an image with the correct proportions, the window needs to be ...
awallace
How do I insert a reference to a dynamically generated table variable name inside a column formula such that I can later change the table variable and still have the column values update. And then do this for a unknown number of columns. dt = Current Data Table();
NewCol = function({ColNr},
//Set a name table variable with the name of the column and RMSE appended to it
dt << Set Table Variable...
Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
HI All,is there a way to use default color scheme for "add graphic script" when adding multiple lines and text?e.g in below code i want to use default color scheme for lines and text instead of hard coded.Motivation: I have to match the color of data to the lines and text, where my data is colored by a group.Line Style( 0 );
Pen Color( 6 );
Pen Size( 2 );
Text Size( 10 );
Try( X Function( 315.4, y, Ma...
dear all: i have to monito abnomal ratio every day, but now everyday i open the JMP and then put excel data in JMP to analyse, that is trouble。 if i open jmp and then analyse automaticly how i write JSL to realize?
Hi, everyoneI can create a button named as "Back". But may I know is there any function that can back to the previous interface when i click the back button?
Thanks.
In the process of putting togother a lengthy script that makes some calls to ODBC/SQL databases that can each take several minutes to run. In an ideal world I could be waiting for multiple servers to get back to me at the same time. From what I am gathering I have to stick with just running one database request after another?I am running JMP 9.
Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?
Thanks.
In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...