JMP User Community

Latest Discussions

Script to create a new data table by subtracting one data table from another.

I have two data tables in my project and am trying to write a script that would like to create a third data table which is the values in table #2 subtracted from table #1. Categorical variable columns and column names are the same in both tables and would need to be the same in table #3. I'm using JMP pro 16.
Mcc99

Discussions |
Feb 27, 2024 6:06 AM

1694 views | 2 replies
Subtract between multiple columns

dt = current data table(); For ( i=0 , i<8, i++, dt << new column( "RESULT", Numeric, "Continuous", For (x=1, x<50, x++, Formula(Column(3+i)[x]-Column(2+i)[x]), )); ); I would like to subtract data between multiple columns, i have tried the script above but its not working. Is there a more effective way to do it?Expected result:result = data2 - data1result1 = data4 - data3result2 = d...
kuanaunwei

Discussions |
Feb 26, 2024 11:50 PM

3046 views | 4 replies
How to provide column names manually in script for importing multiple text files?

Hello, I was able to use the import multiple files tool to get a Skelton script. I would like to add column names to created table through the script. Is there a way to do that?
Singhthisside

Discussions |
Feb 26, 2024 9:27 AM

953 views | 1 replies
A way to show a date with no data in graph builder

Hye everyone,I have a chart where I'd like to show each day and if there is no data for the day the date would still show but be blank. Here you can see that there is no data for the 22nd. However, I would like that date to still show up. I'm thinking I might have to use JSL to check that there is a day for ach day possible between the min and max dates in the data set and add in a dummy line it...
shampton82

Discussions |
Feb 26, 2024 8:00 AM

2632 views | 4 replies
How do I get a list from an SQL query and let the user select the option from the list?
GgGgGg2024

Discussions |
Feb 26, 2024 6:36 AM

1753 views | 3 replies

Previous
Next

Latest Discussions

How to provide column names manually in script for importing multiple text files?

Hello, I was able to use the import multiple files tool to get a Skelton script. I would like to add column names to created table through the script. Is there a way to do that?
Singhthisside

Discussions |
Feb 26, 2024 9:27 AM

953 views | 1 replies
How do I get a list from an SQL query and let the user select the option from the list?
GgGgGg2024

Discussions |
Feb 26, 2024 6:36 AM

1753 views | 3 replies
Strange error running JSL as add-in vs script.

Hi All, I have a script that I've written that I turned into an add-in. Things were working great the last time I used it, around Nov. 2023. I'm running it again, and I'm getting a very strange error/mistake that happens when I run it as an add-in, but it doesn't happen when I just run the JSL file on it's own. So, the script runs some modeling and generates an output window that is supposed t...
SDF1

Discussions |
Feb 23, 2024 9:17 AM

2531 views | 6 replies
group file name and set lable by JSL looping, work fine but slowly

I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...
BayesRabbit7133

Discussions |
Feb 22, 2024 12:24 AM

860 views | 0 replies
Working on multiple data files and creating a summary table that contains the mean, std, etc.

Hi, Lets say we have multiple big class data files, with different height, weight column, etc and I want to create a summary table that contains the mean, standard deviation, cpk, Spec limits, etc. I want to have a summary data table that lists the mean for example, for the first big class file, do the same thing for the next big class file. Is there are a method that I can use to perform such ...
RA899

Discussions |
Feb 21, 2024 10:07 AM

1636 views | 3 replies

Previous
Next

Latest Discussions

group file name and set lable by JSL looping, work fine but slowly

I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...
BayesRabbit7133

Discussions |
Feb 22, 2024 12:24 AM

860 views | 0 replies
Scheduled job failed

Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?
shaiv90

Discussions |
Feb 11, 2024 11:09 PM

832 views | 0 replies
PickFile(), Projects and Network Drives

Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory"; Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...
hogi

Discussions |
Feb 9, 2024 3:07 PM

886 views | 0 replies
How might I include a line break (or a second line) in the print header of a PDF generated from a Journal window?

w = New Window("window", <<Journal, hlb = hlistbox() ); w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" ); w << SavePDF ( "C:\Users\blahblah.pdf");The above script should include a line break in the "left header" so that it has two lines. Instead the resulting PDF just has a non-printing box character between the two words, like this ... and if i copy that text into this wi...
mann

Discussions |
Jan 31, 2024 6:25 AM

1092 views | 0 replies
GraphBuilder Legend hook

There are many useful instances of being able to have a hook onto the selection state change of a legend for a chart / graph. With the non graph-builder method of generating charts' and graphs' legends (using Row Legend()), this was quite simple as the display element was simply a Table Box() that can receive a Set Row Change Function() message. The same cannot be done (to my knowledge) with Gra...
ErraticAttack

Discussions |
Jan 17, 2024 6:41 PM

747 views | 0 replies

Previous
Next

Welcome to the JMP User Community!

Learning Resources

Latest Discussions

Script to create a new data table by subtracting one data table from another.

Subtract between multiple columns

How to provide column names manually in script for importing multiple text files?

A way to show a date with no data in graph builder

How do I get a list from an SQL query and let the user select the option from the list?

Latest Discussions

How to provide column names manually in script for importing multiple text files?

How do I get a list from an SQL query and let the user select the option from the list?

Strange error running JSL as add-in vs script.

group file name and set lable by JSL looping, work fine but slowly

Working on multiple data files and creating a summary table that contains the mean, std, etc.

Latest Discussions

group file name and set lable by JSL looping, work fine but slowly

Scheduled job failed

PickFile(), Projects and Network Drives

How might I include a line break (or a second line) in the print header of a PDF generated from a Journal window?

GraphBuilder Legend hook

JMP Events

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