JMP User Community

Latest Discussions

Issue when doing if a list contains str from a list: return with wrong list

I want to get a list of files that contain str from another list, but the return is empty. What did I do wrong? Can someone advise? Below is my script. filelist = Files In Directory( path ); //filelist={"123_123_1_acdr.csv", "234_113_100_rqtfgy.csv", "53_1243_12_qqwed.csv", "6_12378_23_rty.csv"} lst1 = {"234_113_100", "53_1243_12"}; lst2 = {}; For( i = 1, i <= N Items( filelist ), i++, If( Con...
dadawasozo

Discussions |
Apr 8, 2022 3:53 PM

1243 views | 3 replies
Questions regarding Response Surface Methodology (Box-Behnken design matrix)

Good morning, I am currently trying to optimize some enzymatic reactions using Response Surface Methodology, in concrete, Box-Behnken design matrix. Using the program, you choose your independent variables or factors (pH, temperature, enzyme load, etc) and assign a "low" and "high" value to each. The program then automatically calculates the "middle" value. My first question is if it is possible...
MANOVAWoodchuck

Discussions |
Apr 8, 2022 3:12 PM

2260 views | 2 replies
Find location of item in a list that partially matched to a string (search list by partial match)

Can't find a good way of doing this task.Let's say I have this:list = {"big apple", "big orange", "big pear"}; string = "orange";How do I find a location of an item in the list that partially matches to the string?
miguello

Discussions |
Apr 8, 2022 3:01 PM

1562 views | 2 replies
How do I Use Boolean Logic on Continuous Factor to Create a DoE

Hello. Thank you in advance for your time to consider this problem. I am trying to create a DoE with 2 continuous factors and a 2-Level discrete numeric factor.I want to create a DoE in which if the discrete numeric factor value is 1, only range of values from the 1st continuous factor is experimented. And, if the discrete numeric factor value is 2, only range of values from the 2nd continuous fac...
ExplanatoryLynx

Discussions |
Apr 8, 2022 2:32 PM

1484 views | 3 replies
How to create subcategories for rows and columns similar to tabulate

I'm currently working on creating a data table of results from a SQL query. The final data table has a set up that merges the shared column groups and merges the rows of shared values as well (see Table 1). The data sometimes has numeric values, but most of the results are strings like "Negative" or "< 0.1". The way I summarize the data table with the character/nominal values is by transposing the...
svarga

Discussions |
Apr 8, 2022 11:08 AM

3304 views | 4 replies

Previous
Next

Latest Discussions

Questions regarding Response Surface Methodology (Box-Behnken design matrix)

Good morning, I am currently trying to optimize some enzymatic reactions using Response Surface Methodology, in concrete, Box-Behnken design matrix. Using the program, you choose your independent variables or factors (pH, temperature, enzyme load, etc) and assign a "low" and "high" value to each. The program then automatically calculates the "middle" value. My first question is if it is possible...
MANOVAWoodchuck

Discussions |
Apr 8, 2022 3:12 PM

2260 views | 2 replies
How do I Use Boolean Logic on Continuous Factor to Create a DoE

Hello. Thank you in advance for your time to consider this problem. I am trying to create a DoE with 2 continuous factors and a 2-Level discrete numeric factor.I want to create a DoE in which if the discrete numeric factor value is 1, only range of values from the 1st continuous factor is experimented. And, if the discrete numeric factor value is 2, only range of values from the 2nd continuous fac...
ExplanatoryLynx

Discussions |
Apr 8, 2022 2:32 PM

1484 views | 3 replies
3-way Anova_ Lost DFs problem

Hello, in my experiment I have two group of different cultures, each group is made of female and male (gender) and each participants can give correct and incorrect response, to the stimuli which are black/n/white or coloured. I tryed to perfom a 3-way anova with the fit model Y=response time (continuos variable) and X I did a full cross with culture, gender and colour; I also nest subjects with ge...
Valee

Discussions |
Apr 7, 2022 5:52 AM

778 views | 1 replies
请问表格文件损坏能否修复？

大家好! 压缩格式的表格文件能否修改？谢谢！
lala

Discussions |
Apr 7, 2022 5:51 AM

1018 views | 2 replies
JSL vs VBA

我想看看代码之间如何互相转换。谢谢!具体的内容在下面(看看英文的标题、社区的自动翻译的效果怎样)。
lala

Discussions |
Apr 6, 2022 2:48 AM

1236 views | 3 replies

Previous
Next

Latest Discussions

Column Switcher Button Removed from Plot Window Toolbar in JMP 16 for Mac

Recently switched from JMP15 for Mac to JMP16 for Mac. I was surprised to see the column switcher button removed as an option in an analysis/plot window. It used to reside up top next to the local data filter button (see black circle). The option to customize it back is also missing and has been replaced by a 'properties' button. This may also prove useful but I'm new to it. To get the colum...
datanaut

Discussions |
Mar 17, 2022 3:18 PM

857 views | 0 replies
No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

612 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

794 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

603 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1408 views | 0 replies