JMP User Community

Latest Discussions

Extract a value from text

Hi,Is it possible to extract the 550 value from the text below using JMP formula that i could then imbedded into script. The over all shape and number of characters will change but the expression of std Pli = will stay the same.Any help would be greatly appreciated. Thanks,Tomasz PP, PPr (don’t forget to measure standard wafer SMM PPr WAL S0782-3, "Redarect PPr new" recipe (On WE9LDIP ONLY)) and U...
swiergi11

Discussions |
May 13, 2021 9:00 AM

1361 views | 3 replies
Scripting open CSV with both file dialog picker and column definitions.

Hi, Working on an automation of an analysis and getting hung up on the first step of importing a csv file. My approach is to use the automatically generated scripts as a basis.The following script works on my test file and I would like to modify to use the file browser to pick a file instead of the current hard coding.The scripting documentation states that if the file path string is not present ...
Hegedus1

Discussions |
May 13, 2021 7:41 AM

1367 views | 2 replies
join data based on approximate time stamp

I have two data tables that i need to join. table A has time stamps in hours: 24, 48, 72, 96,.... table B has online data with 5 minute intervals, so the time stamp must have several decimal places to capture the precision: 1.000, 1.083, 1.167, 1.250, 1.333, 1.417, 1.500 etc. joining B to A works well. these is no problems because there is always a whole number match of time stamp in table B wi...
tatersalad

Discussions |
May 13, 2021 4:21 AM

1319 views | 2 replies
How do I Script to Change Selected Column Names

Hi, is there a script for me to select the last 10 columns in my table (the ones after "Transition?") and add ".Cv" at the end of the original column name? I tried writing my script but it did not work: dt = Current Data Table(); ColList = dt << get column names( string ); For( i = 11, i <= N Items( ColList ), i++, // set which column that look sat grade spec limits NewName << ColList[i] || ".Cv";...
ShahirahLoqman

Discussions |
May 13, 2021 3:28 AM

6199 views | 3 replies
Question regarding error bars in graph builder

When we build a BAR graph and use the nested mode we cannot see the "standard error" or "standard deviation" on the graph. This is consistent in any data set we use. In excel it is possible to do it.It is very crucial for us to show the SE or SD of the mean bars.For example, in this attached graph we wish to have an SE on the Blue Bar and also on theRed Bar each for his on dataset.Can I get some ...
NirS

Discussions |
May 12, 2021 10:34 AM

742 views | 1 replies

Previous
Next

Latest Discussions

Extract a value from text

Hi,Is it possible to extract the 550 value from the text below using JMP formula that i could then imbedded into script. The over all shape and number of characters will change but the expression of std Pli = will stay the same.Any help would be greatly appreciated. Thanks,Tomasz PP, PPr (don’t forget to measure standard wafer SMM PPr WAL S0782-3, "Redarect PPr new" recipe (On WE9LDIP ONLY)) and U...
swiergi11

Discussions |
May 13, 2021 9:00 AM

1361 views | 3 replies
join data based on approximate time stamp

I have two data tables that i need to join. table A has time stamps in hours: 24, 48, 72, 96,.... table B has online data with 5 minute intervals, so the time stamp must have several decimal places to capture the precision: 1.000, 1.083, 1.167, 1.250, 1.333, 1.417, 1.500 etc. joining B to A works well. these is no problems because there is always a whole number match of time stamp in table B wi...
tatersalad

Discussions |
May 13, 2021 4:21 AM

1319 views | 2 replies
Question regarding error bars in graph builder

When we build a BAR graph and use the nested mode we cannot see the "standard error" or "standard deviation" on the graph. This is consistent in any data set we use. In excel it is possible to do it.It is very crucial for us to show the SE or SD of the mean bars.For example, in this attached graph we wish to have an SE on the Blue Bar and also on theRed Bar each for his on dataset.Can I get some ...
NirS

Discussions |
May 12, 2021 10:34 AM

742 views | 1 replies
Custome DOE: Controlling a factor so that it cannot repeat in run order

I am attempting to create a DOE with 2 factors we will call them configuration ( a 3 level categorical) and operator (also a 3 level categorical). I am trying to figure out a way in which JMP will allow me to create the DOE with a run order condition. The condition I need to set is that the same operator may not do two consecutive trials. I.e. Run 1 is Configuration 1, Operator 1 and Run 2 i...
A4Man2310

Discussions |
May 12, 2021 9:05 AM

802 views | 1 replies
How to add data values to a table in a for loop using Select Columns Where to make a new overall data table of target data

For( date = date_array << First, !Is Empty( date ), date = date_array << Next( date ), //looping through date_array's keys is clunky but done this way in JMP dt << Select Columns( :Timepoint, :Target Channel, :Run date ), Where(:Timepoint == date); dt << Subset( ( Selected Rows ), Output Table Name( "Subset" )); );I wish to add, progressively, through each iteration of a for loop, data specifie...
mostarr

Discussions |
May 12, 2021 1:35 AM

2602 views | 5 replies

Previous
Next

Latest Discussions

Can I control text size in a word cloud inside a dashboard container?

Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...
caseylott

Discussions |
Apr 28, 2021 12:03 PM

1005 views | 0 replies
多重比較での生存曲線の書き方　Bonferroniなど

4群での生存曲線をJMPproでの書き方を教えて下さい。また、JMPで「環境設定グループ」から「レポート」を選択し、「ローカルデータフィルター」を出せればできる方法も紹介されていたのですが、「ローカルデータフィルター」を出せません。どの方法でもよいので、JMPProで、多重比較法を用いた生存曲線の書き方をどなたか教えてください！宜しくお願い致します。
27070

Discussions |
Apr 20, 2021 1:41 AM

1953 views | 0 replies
Fantasy Baseball League

I am in a 16 team fantasy baseball league. Each week we tabulate totals for home runs, batting average, stolen bases, wins, saves, era, etc. If my team has the most home runs, I win that category for the week. We track 10 statistics so after each week I may have a final score of 6-3-1. My question is how can I use JMP to check what my score would have been if I had played each of the other 14 team...
atlas100

Discussions |
Apr 19, 2021 1:29 PM

793 views | 0 replies
Generation of overdispersed poisson count data (vs gamma poisson)

Hello, I would like to reconcile the parametrization used in the Random Gamma Poisson(lambda, sigma)with the over-dispersion parameter as estimated in generalized linear model platform. Take for instance the attached table. Here the generating function is Random Gamma Poisson(exp(1+3*:X1),10)Running glm with poisson/log + overdispersion I obtain: Overdispersion = 6.09. Is there any way to link...
matteo_patelmo

Discussions |
Apr 12, 2021 9:53 AM

955 views | 0 replies
JSL Syntax Change is coming: Name() is being deprecated

Hi All, I just read here that the JSL syntax for referencing a column using the Name() parser is going away. The new syntax is currently in use and at some point the old syntax will be removed entirely. There's a lot of people here who script, so thought it would be good to post something here. I know I have a lot of code I'll need to change! Better to be ahead of the curve and change it befor...
SDF1

Discussions |
Apr 7, 2021 10:14 AM

689 views | 0 replies