JMP User Community

Latest Discussions

Table Update: How to update only selected columns?

This should be a quick one:Table update: How to update only selected columns? Data Table( dt1 ) << Update( With( Data Table( dt10 ) ), Match Columns( :SAMPLE = :SamID ), Add Columns from Update Table( None ), ### Update Selected Columns (:Type, :Method) ### )It's simple when done manually, but in the script? There's nothing in the scripting guide (only how to avoid adding columns). My variou...
Monomorphist

Discussions |
Feb 27, 2023 5:58 AM

2348 views | 2 replies
How to use JSL to calculate a curve whether the lines of each adjacent high point of multiple different peaks are the same line?

Hello, everyone!Is there any existing module or function for this function?
How can this be done quickly?Thanks!
UersK

Discussions |
Feb 25, 2023 4:25 AM

1269 views | 2 replies
How to read two rows from txt-file as column name

Hello, Is there an option in JSL to read in the first two lines of a text file as a column header or
alternatively (and even better) the first as Column name and the second as the column property (Units)Thank youMirko @martindemel
mlo1

Discussions |
Feb 23, 2023 8:42 AM

4441 views | 6 replies
Color specific column by JSL

Hello
I tried to color in red the value "The First Bin Fail" in column "FIRST_BIN". and JSL colored all the table in redcan you explain where I did go wrong in my script? dt << Select where ( :FIRST_BIN == "The first Bin Fail") << Color Cells ("Light Red"); Provide a table how I need to color it:
Dennisbur

Discussions |
Feb 23, 2023 4:50 AM

1683 views | 2 replies
JMP 17 frequently crash when running add-in

Hi Expert, I just upgrade my license from JMP16 to JMP 17. I've build an add-in that works fine in JMP16 (both add-in & script).But after upgraded to JMP17, I faced frequent JMP error while running add-in & script like below when i click on the chart. I already un-install the add-in & re-install back because I thought my script not compatible.Still issue persist. Do we have some sort of JMP versio...
WebDesignesCrow

Discussions |
Feb 22, 2023 7:35 PM

2914 views | 4 replies

Previous
Next

Latest Discussions

How to use JSL to calculate a curve whether the lines of each adjacent high point of multiple different peaks are the same line?

Hello, everyone!Is there any existing module or function for this function?
How can this be done quickly?Thanks!
UersK

Discussions |
Feb 25, 2023 4:25 AM

1269 views | 2 replies
Delete selected data in the cell

HelloI have table and I would like to delete specific data in cell.for example with this condition as well:1) if CORNER = VMAX2) if MODUL = IIH3) if PARAMETR = GPIO & MIPI4) if LO_LIMIT is not 0Delete the data of LO_LIMIT for these criteria at the end I would like to receive data tablecan you assist me in JSL script for this task?
Dennisbur

Discussions |
Feb 21, 2023 1:45 AM

952 views | 1 replies
Dynamically put selected Local Data Filter parameter to y-axis label on a chart

I have got a three column data. Column - 1 is "Part ID", Column-2 is "Tested Parameter Name" and Column - 3 is "Measured value" of each tested parameter.There are five test parameters for each part so the Part ID changes after every 5 row entries.I am plotting "Measured value" of the tested parameter on y-axis and "Part ID" on the x-axis.I have got local data filter open on the "Tested Parameter N...
Neo

Discussions |
Feb 17, 2023 7:28 AM

3451 views | 7 replies
problème importation date à partir d'excel

bjr, j'ai ce fichier excel avec 2 colonnes date. quand j'importe directement dans Jmp, la prévisualisation donne ceci:quand j'importe, j'ai ceci:si je passe par un script comme ceci:Names Default To Here( 1 ); dt1 = Open( "/E:/Pb date.xlsx", Worksheets( "Feuil1" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), Worksheet Settings( 1,...
Françoise

Discussions |
Feb 14, 2023 10:39 PM

3138 views | 3 replies
How to use JSL to split a contiguous binary file into segments in bytes?

This is what happens after reading binary files with JSL:It's segmented by 12 bytes
b = Load Text File( "……\abc.spr", blob() );Thanks Experts!
lala

Discussions |
Feb 12, 2023 11:56 PM

2379 views | 6 replies

Previous
Next

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

910 views | 0 replies
C Stack Usage Error When Sending Code to R

Hello, I'm trying to invoke some commands in R using the R Submit function in JSL and am getting the error below. Is this an issue with JMP17 and R integration? It only happens when I invoke a specific package using JSL so it's hard for others to replicate w/o installing R and the package as well. I'm using JMP 17.0 and R 4.2.0. Never saw this error with JMP 16. "Error: C stack usage 4123778 is to...
vigslayer

Discussions |
Dec 15, 2022 8:14 PM

1102 views | 0 replies
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

866 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

910 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

825 views | 0 replies

Previous
Next

Welcome to the JMP User Community!

Learning Resources

Latest Discussions

Table Update: How to update only selected columns?

How to use JSL to calculate a curve whether the lines of each adjacent high point of multiple different peaks are the same line?

How to read two rows from txt-file as column name

Color specific column by JSL

JMP 17 frequently crash when running add-in

Latest Discussions

How to use JSL to calculate a curve whether the lines of each adjacent high point of multiple different peaks are the same line?

Delete selected data in the cell

Dynamically put selected Local Data Filter parameter to y-axis label on a chart

problème importation date à partir d'excel

How to use JSL to split a contiguous binary file into segments in bytes?

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

C Stack Usage Error When Sending Code to R

How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

How to Analyze and Graph Responses with Supercategories

標準化列名稱如何用變數取代求解

JMP Events

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration