JMP User Community

Latest Discussions

Joining / Concatenate table but just include new data

Hi all,I have scheduled a JMP script to give me a daily data table each day.What is the best way to Concatenate these tables, but I only want to add new data and not have multiples.Example Table 1 (Day 1) and then table 7 (Day 7), how do you concatente these tables to have Table 1 and all new data in Table7 included, but not multiples. Note, Column names will be the same in each table.
ivan_j_moore

Discussions |
Aug 29, 2016 8:53 AM

8807 views | 5 replies
Setting values to a cell

Hello all,It's been some time since I did any programming in JSL, so I'll be asking some basics questions which I did not find in the manuals.1. How, using a JSL, I can set a specific value to a specific Col/Row?2. I need to do that in a For loop. Let's say I need to run a loop from 1 to number of rows, and assign (for now) the same number to each Row of a Specific column. How do I do that this wa...
miguello

Discussions |
Aug 29, 2016 7:04 AM

13551 views | 2 replies
Hexadecimal to decimal

I have a column that has number in the format of 0x1, 0x5, 0xe - how do I convert these hexadecimal to decimal?Thanks!
miguello

Discussions |
Aug 29, 2016 5:07 AM

17419 views | 3 replies
Cycle detected for data column

Hello, AllI am making a model that requires some "loop feedback", and it is giving me this error:Do you know how to get around it?I do not have this problem in Excel using the same formulaeThank you,-JoseUPDATE:I was able to make it run, but it will only execute the formula on one row at the time.I am attaching the table script for reference.You will see that two columns are dependent from each ot...
gutloja

Discussions |
Aug 28, 2016 10:56 AM

7516 views | 4 replies
Is there a way to save a subsetted table back to the originating / primary table (similar to save script) ?

As above
John_K

Discussions |
Aug 28, 2016 10:32 AM

11113 views | 3 replies

Previous
Next

Latest Discussions

Joining / Concatenate table but just include new data

Hi all,I have scheduled a JMP script to give me a daily data table each day.What is the best way to Concatenate these tables, but I only want to add new data and not have multiples.Example Table 1 (Day 1) and then table 7 (Day 7), how do you concatente these tables to have Table 1 and all new data in Table7 included, but not multiples. Note, Column names will be the same in each table.
ivan_j_moore

Discussions |
Aug 29, 2016 8:53 AM

8807 views | 5 replies
Cycle detected for data column

Hello, AllI am making a model that requires some "loop feedback", and it is giving me this error:Do you know how to get around it?I do not have this problem in Excel using the same formulaeThank you,-JoseUPDATE:I was able to make it run, but it will only execute the formula on one row at the time.I am attaching the table script for reference.You will see that two columns are dependent from each ot...
gutloja

Discussions |
Aug 28, 2016 10:56 AM

7516 views | 4 replies
control chart with multiple items how to save summaries in one table

I have a control chart (cc) window with multiple items (i.e. each item has a control chart). In jsl, when I use cc<< Save Summaries, it pops up a summary table for each item. How can I save all summaries in one table with item name identified? Thank you.
qy6b0

Discussions |
Aug 25, 2016 5:29 PM

8221 views | 5 replies
Extract list from Get List Check-command

Using the Get List Check command I get the following:LC = col << Get List CheckThe Log will showLC = List Check({"Argon", "Krypton", "Air"});How do I extract the list from inside the List Check()-statement? I want to end up with a variable containing the list.LC_list = {"Argon", "Krypton", "Air"}
martin_snogdahl

Discussions |
Aug 24, 2016 2:35 AM

4482 views | 1 replies
Automatic Recalc

Is is possible to select Automatic Recalc in Preferences? I have looked for it but cannot find it there. Auto Recalc is a very useful feature in some other software packages I use and it would be great in JMP.
Steven_Moore

Discussions |
Aug 23, 2016 4:52 PM

11199 views | 6 replies

Previous
Next

Latest Discussions

Odds ratios for multiway tables

On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

4888 views | 0 replies
How to find ETA squared effect size for MANOVA?

Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

3909 views | 0 replies
Is there an easy way to get the FWHM (full width half max) of a curve using JMP?

Dear JMP community,Is there an easy way to get the FWHM (full width half max) of a spectral curve using JMP? Finding the minima and maxima are fairly straightforward, but then calculating the FWHM seems to be much more laborious in JMP, especially if the data is sparse and we would like to interpolate to get more accurate intersections between the peak and the FWHM value. In my case, the peak is o...
mcjorge

Discussions |
Jul 22, 2016 8:13 AM

5192 views | 0 replies
Co-Kriging with JMP and Matlab

Hi!I was wondering if anyone already tried to work with Co-Kriging, using JMP together with Matlab. As JMP only fits Ordinary Kriging Models (Gaussian Process with Gaussian Correlation Function), I would like to send data (generated with Space Filling JMP Platform) from JMP to Matlab, fit the models there (Matlab), and bring the MODELS back to JMP, to use inside Profile Platform. Do you have any e...
samuelbbaco0

Discussions |
Dec 4, 2015 12:32 PM

3618 views | 0 replies
Interpreting canonical structure and scores in discriminant analysis

I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
amzipkin

Discussions |
Oct 20, 2015 3:25 PM

3589 views | 0 replies