If column exists?
Hi-
Would like to write a simple statement in script like,
If column_name exists then
do stuff
End If
Is it possible?
Dave

Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resources
Hi-
Would like to write a simple statement in script like,
If column_name exists then
do stuff
End If
Is it possible?
Dave
i m new to JMP 7.
I want to calculate the area under a Curve, using the Trapezium rule.
can any one tell me how to do this?
thank you ....
Message was edited by: pg_microbio
Hi,
I have a table, each of its columns usually is assgned with a prettly long name for easy interpretation.
So after I generate or load it into JMP, each time I have manually adjust each column to make sure
its full name can be shown properly.
But this is too annoying when columns are too many.
So if I can control its display by JSL, any idea I can make this automatic column width adjustment?
Th...
In JMP we can do calculation using the JMP calculator.
The parameters in the formula are the columns table, attached is a simple formula subtracting y column from x column with LAG,
What I want to know is if there is a way to use different lag for different rows.
((Lag( x, 2 ) - :y) / Lag( x, 2 )) * 100
Thank you
Yaakov
Hi, all
I met a problem in extracing a numeric value from a display box object.
It is very tricky and could not figure it out.
I have following table "Data.jmp", and try to fit its distribution using following JSL code:
dt = CurrentDataTable();
div = Distribution( Stack( 1 ),
Continuous Distribution(Column( :Value ), Horizontal Layout( 1 ), Vertical( 0 ),
Fit Distribution( Normal(Goodness of ...
Hi-
Would like to write a simple statement in script like,
If column_name exists then
do stuff
End If
Is it possible?
Dave
Hi,
I have a table, each of its columns usually is assgned with a prettly long name for easy interpretation.
So after I generate or load it into JMP, each time I have manually adjust each column to make sure
its full name can be shown properly.
But this is too annoying when columns are too many.
So if I can control its display by JSL, any idea I can make this automatic column width adjustment?
Th...
In JMP we can do calculation using the JMP calculator.
The parameters in the formula are the columns table, attached is a simple formula subtracting y column from x column with LAG,
What I want to know is if there is a way to use different lag for different rows.
((Lag( x, 2 ) - :y) / Lag( x, 2 )) * 100
Thank you
Yaakov
Hi, all
I met a problem in extracing a numeric value from a display box object.
It is very tricky and could not figure it out.
I have following table "Data.jmp", and try to fit its distribution using following JSL code:
dt = CurrentDataTable();
div = Distribution( Stack( 1 ),
Continuous Distribution(Column( :Value ), Horizontal Layout( 1 ), Vertical( 0 ),
Fit Distribution( Normal(Goodness of ...
Does anyone use JMP to work with their Flow Cytometry data? We use FlowJo to analyze data but would like to use JMP to graph and summarize data. I have been asked to find out if others are doing this as well. Any references to papers that show the use of JMP would be helpful as well.
Thanks
We hope you'll find this forum useful as a place to connect with other users of JMP Software, pose questions and share your expertise in using JMP. Topics may include, but are not limited to: data visualization, Design of Experiments (DOE), exploratory data mining, programming with the JMP Scripting Language (JSL), quality, statistical procedures using JMP and Visual Six Sigma.
Please note that thi...
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
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...