cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Claus_Jensen
Level I

Copy Cell value to column name and to spec limits

Hi All

 

I have i challenge i need to coly the values of the cell in rownumber 8 to the column name for a lot of collums is there an easy way to script this.

 

My next issue is that i have spec limits both low and high including Sepc units in 3 diffe rows is there a way to script this to the Spec limits om the column

1 ACCEPTED SOLUTION

Accepted Solutions
ian_jmp
Level X

Re: Copy Cell value to column name and to spec limits

For the first part, you could try something like this:

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

Wait(3);

for(c=1, c<=NCol(dt), c++, Column(dt, c) << setName(Char(Column(dt, c)[8])));

For the second part, take a look at 'Analyze > Quality and Process > Manage Spec Limits' and the associated help.

View solution in original post

1 REPLY 1
ian_jmp
Level X

Re: Copy Cell value to column name and to spec limits

For the first part, you could try something like this:

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

Wait(3);

for(c=1, c<=NCol(dt), c++, Column(dt, c) << setName(Char(Column(dt, c)[8])));

For the second part, take a look at 'Analyze > Quality and Process > Manage Spec Limits' and the associated help.