cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-443687%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ECopiar%20el%20valor%20de%20la%20celda%20al%20nombre%20de%20la%20columna%20y%20a%20los%20l%C3%ADmites%20de%20especificaci%C3%B3n%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443687%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EHola%20a%20todos%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ETengo%20un%20desaf%C3%ADo%3A%20necesito%20copiar%20los%20valores%20de%20la%20celda%20en%20la%20fila%20n%C3%BAmero%208%20al%20nombre%20de%20la%20columna%20para%20muchas%20columnas.%20%C2%BFHay%20alguna%20manera%20f%C3%A1cil%20de%20escribir%20esto%3F%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EMi%20pr%C3%B3ximo%20problema%20es%20que%20tengo%20l%C3%ADmites%20de%20especificaci%C3%B3n%20tanto%20bajos%20como%20altos%2C%20incluidas%20las%20unidades%20Sepc%20en%203%20filas%20diferentes.%20%C2%BFHay%20alguna%20manera%20de%20escribir%20esto%20en%20los%20l%C3%ADmites%20de%20especificaci%C3%B3n%20de%20la%20columna%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-443687%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EAutomatizaci%C3%B3n%20y%20scripting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-443728%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20copiar%20el%20valor%20de%20la%20celda%20al%20nombre%20de%20la%20columna%20y%20a%20los%20l%C3%ADmites%20de%20especificaci%C3%B3n%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443728%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EPara%20la%20primera%20parte%2C%20puedes%20probar%20algo%20como%20esto%3A%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENamesDefaultToHere(1)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0A%0AWait(3)%3B%0A%0Afor(c%3D1%2C%20c%26lt%3B%3DNCol(dt)%2C%20c%2B%2B%2C%20Column(dt%2C%20c)%20%26lt%3B%26lt%3B%20setName(Char(Column(dt%2C%20c)%5B8%5D)))%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EPara%20la%20segunda%20parte%2C%20eche%20un%20vistazo%20a%20'Analizar%26gt%3B%20Calidad%20y%20proceso%26gt%3B%20Administrar%20l%C3%ADmites%20de%20especificaciones'%20y%20la%20ayuda%20asociada.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.

Recommended Articles