How to write a JSL script to copy and paste a data table Source into another data table?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resources
Hi there. I'm having a knightmare setting constraints in JMP for a Space Filling DOE. I want to explore the DOE space fully, but without driving test samples to failure. So, I have generated a table to set maximum limits of one of the factors as a function of another 2 factors. I don't seem to be able to use the table directly, so am trying Use Disallowed Combinations Script. Trying a bicubic equa...
After running a general query to collect lots of data with general header of bin01, bin02, .... bin16. I want to update column headers based on a different able that has bin information based on recipe. This seems an easy task using a munger command, but errors when placed into a nested loop. Same syntax works in a single loop format, but since there will be a variable number of bin values to r...
I'm having an issue combining Graph Builder and Local Data Filter within Fit Group. As soon as the Local Data Filter is applied to the Fit Group, all of the Graph Builder objects immediately disappear. (Note, other platforms like Bivariate and Oneway are not affected by this and those windows remain after applying the Local Data Filter, only the Graph Builder windows disappear.) Here is a sample s...
I have a data set with groups, days and visits on those days. I would like to get a rolling sum of every 3 days, so at day 3 the value would be sum of day 1, 2, 3, but on day 4 the value is the sum of days 2, 3,4. And do this by group. I know I can use the cumulative sum by group, but that returns the sum each day, so day 4, would be the sum of all 4 days, but I would like the first day to dro...
I'm having an issue combining Graph Builder and Local Data Filter within Fit Group. As soon as the Local Data Filter is applied to the Fit Group, all of the Graph Builder objects immediately disappear. (Note, other platforms like Bivariate and Oneway are not affected by this and those windows remain after applying the Local Data Filter, only the Graph Builder windows disappear.) Here is a sample s...
I have a data set with groups, days and visits on those days. I would like to get a rolling sum of every 3 days, so at day 3 the value would be sum of day 1, 2, 3, but on day 4 the value is the sum of days 2, 3,4. And do this by group. I know I can use the cumulative sum by group, but that returns the sum each day, so day 4, would be the sum of all 4 days, but I would like the first day to dro...
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...
Scenario: I have 8 compounds A-H, for each compound I have 5 runs* of time-temperature data with a known category. I need to be able to compare a single data run of an unknown category to those existing runs and assign a category to that run. A few things going on which may also need accounted for:1) My start times (when heating began vs the data run started) do not all align.2) Not all runs end a...
Hello, I have a data table with several continuous columns, each column with a different name. I wish to: 1) duplicate continuous columns all at once; 2) rename these new columns with their original names (i.e., lady beetle) plus add "/100" to their names (i.e., column name would be: lady beetle/100) all at once; then 3) I want to multiply these new columns by 4 all at once (only the continuous co...
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...
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.
//新增周標準化
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( ...
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
...
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...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...
Jump into Graphing Date: Wednesday, September 24Time: 1:00 – 2:30 p.m. ETDura...