JMP User Community

Latest Discussions

To open a file through JSL, how can I open the file in a shared way?

For example, if I open a test.CSV file through JSL, how can I use other software to continue to add data to the test.CSV file and save it as a new one?
Of course, there is no need to notify JMP when there is new data. Thanks!
lala

Discussions |
Mar 12, 2024 12:37 PM

855 views | 1 replies
Close Database connection

Hi, Is there a way to close the database connection before running the script?I have an SQL script that crashes JMP if there's an open connection, so I'm trying to figure out a way to close all the connections before running the script. Thanks,
Jackie_

Discussions |
Mar 12, 2024 11:45 AM

1145 views | 2 replies
Multiple File Import, file filtering

Hello everyone, JSL newbie here! I need to Import Multiple Files, where the file names that are imported have some parameters that need to be met. Cannot contain certain characters. These characters are always at the end of the file name.Must include a certain stringIf there are identical string segments within the file names found, only the one with the most recent system date & time stamp are i...
StarfruitBob

Discussions |
Mar 12, 2024 9:12 AM

6302 views | 12 replies
How to replace :column_name with variable in JMP JSL?

@jthiCan you help me to fix the code error below? How to use variable to replace :column name in the correct way? Thank you so much for your help. Names Default To Here( 1 ); Open( "$SAMPLE_DATA/Big Class.jmp" ); hvar = "height"; gvar = "sex"; std = Col Std Dev( if(Excluded( Row State() ) == 0 & column(gvar) =="M", column(hvar) )); //std = Col Std Dev( if(Excluded( Row State() ) == 0 & :sex =="M...
lazzybug

Discussions |
Mar 12, 2024 8:53 AM

1827 views | 3 replies
Why is it not a good idea to set continuous factor to zero for RSM

Dear JMP-Experts, I have quite often the case that continuous factor settings including a zero for lowest factor setting (0, 1, 2) are requested for liquid biotech formulation optimizations. These requests usually come people who are used to set up experiments with OFAT and it is not intuitve for them to understand, that setting factor to zero technical means to have a categorical factor setting.
I...
DualARIMACougar

Discussions |
Mar 12, 2024 8:22 AM

1504 views | 2 replies

Previous
Next

Latest Discussions

To open a file through JSL, how can I open the file in a shared way?

For example, if I open a test.CSV file through JSL, how can I use other software to continue to add data to the test.CSV file and save it as a new one?
Of course, there is no need to notify JMP when there is new data. Thanks!
lala

Discussions |
Mar 12, 2024 12:37 PM

855 views | 1 replies
Close Database connection

Hi, Is there a way to close the database connection before running the script?I have an SQL script that crashes JMP if there's an open connection, so I'm trying to figure out a way to close all the connections before running the script. Thanks,
Jackie_

Discussions |
Mar 12, 2024 11:45 AM

1145 views | 2 replies
Creating a workflow for analysis and plotting of bioassay qualification data

Hi community. I'm looking for support to create a workflow in JMP 17.2 for analyzing and plotting data from bioassay qualification study. Specifically, I'd like to base the calculations of relative bias and intermediate precision on equations provided in regulatory guidelines, USP <1033>. @Valerie_Nedbal, @gail_massari The qualification study design consists of two independent 96WP per run, on ea...
AgnieszkaL

Discussions |
Mar 12, 2024 6:49 AM

833 views | 0 replies
Downloading a file from web with header "content-disposition: attachment"

I would like to download a csv file from a webpage, however when I send the HTTP request the return is Empty(). My code is as follows:request = New HTTP Request( URL( url), Method( "Get" ), Headers( {"Authorization: Bearer " || token} )); data = request << send;I receive the following response header, so I'm confident I am accessing the server: GetResponseHeaders = ["content-disposition" => "attac...
BackwardEffect6

Discussions |
Mar 12, 2024 4:14 AM

1930 views | 1 replies
How to treat replicates and failed runs in a definitive screening design

Hi community, I am having trouble modeling some data that I got from a DSD. This was a screen of 10 factors. We ran this with 3 blocks (operators) and I included the maximum number of extra runs (8). This gave me a table of 31 runs. We did some initial range-finding experiments to set reasonable bounds for all of the factors. Unfortunately we still got 4 runs where the reaction completely failed, ...
ajoneja

Discussions |
Mar 12, 2024 12:51 AM

7157 views | 17 replies

Previous
Next

Latest Discussions

Creating a workflow for analysis and plotting of bioassay qualification data

Hi community. I'm looking for support to create a workflow in JMP 17.2 for analyzing and plotting data from bioassay qualification study. Specifically, I'd like to base the calculations of relative bias and intermediate precision on equations provided in regulatory guidelines, USP <1033>. @Valerie_Nedbal, @gail_massari The qualification study design consists of two independent 96WP per run, on ea...
AgnieszkaL

Discussions |
Mar 12, 2024 6:49 AM

833 views | 0 replies
FDE - How does JMP deal with sparse data if user doesn't perform pre-alignment?

Hi, My question refers to the situation where the user doesn't opt for Direct Functional PCA (Functional Data Explorer Platform Options). By pre-aligment I refer, for instance, to the functions `Reduce` and `Align` detailed in Data Processing Options.I would like to know if, for sparse data (Overview of the Functional Data Explorer Platform), JMP performs an automatic alignment if the user doesn't...
ConstructCoyote

Discussions |
Mar 11, 2024 3:00 AM

590 views | 0 replies
DataTable Prompt in application builder on module load

Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads Kindly guide. Thanks in advance
ComplexNerd

Discussions |
Mar 7, 2024 3:54 AM

553 views | 0 replies
JMP Project Global Data Filter and Column Switcher

Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...
ComplexNerd

Discussions |
Mar 7, 2024 12:10 AM

519 views | 0 replies
Do 3rd order effects help define curvature?

If you have are making a design with a factor you are certain will have a quadratic relationship against a response but you have a wide range, can it be helpful to define a 3rd order model effect for that factor to better identify and model curvature. I work in purification and we often deal with a recovery vs. purity balance. This relationship is usually quadratic around the optimal, where at a l...
MetaLizard62080

Discussions |
Mar 4, 2024 8:21 PM

887 views | 0 replies