cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-595976%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EAgregue%20una%20nueva%20f%C3%B3rmula%20r%C3%A1pida%20que%20se%20puede%20usar%20para%20comparar%20si%20los%20valores%20de%20las%20columnas%20seleccionadas%20son%20los%20mismos%20en%20la%20fila%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-595976%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EDe%20vez%20en%20cuando%20me%20encuentro%20con%20una%20situaci%C3%B3n%20en%20la%20que%20me%20gustar%C3%ADa%20comprobar%20r%C3%A1pidamente%20si%20dos%20columnas%20tienen%20exactamente%20los%20mismos%20resultados%20en%20las%20filas.%20Normalmente%20hago%20esto%20escribiendo%20una%20nueva%20columna%20con%3A%20COL1%20%3D%3D%20COL2%2C%20por%20ejemplo.%20Ser%C3%ADa%20bueno%20tener%20esto%20como%20una%20opci%C3%B3n%20de%20Nueva%20f%C3%B3rmula%20en%20el%20men%C3%BA%20contextual%20(y%2C%20con%20suerte%2C%20admitir%20m%C3%A1s%20de%202%20columnas).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-595976%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3ECombinaci%C3%B3n%20y%20limpieza%20de%20datos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExploraci%C3%B3n%20y%20visualizaci%C3%B3n%20de%20datos%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-598803%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Agregar%20nueva%20f%C3%B3rmula%20r%C3%A1pida%20que%20se%20puede%20usar%20para%20comparar%20si%20los%20valores%20de%20columna%20seleccionados%20son%20los%20mismos%20en%20la%20fila%20-%20Estado%20cambiado%20a%3A%20Reconocido%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-598803%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHola%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%20%40jthi%3C%2FA%3E%20%2C%20gracias%20por%20tomarse%20el%20tiempo%20para%20enviar%20esta%20idea!%20Revisaremos%20su%20solicitud%20y%20lo%20mantendremos%20informado%20sobre%20su%20estado.%3CSPAN%20class%3D%22Apple-converted-space%22%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778617%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20Agregar%20una%20nueva%20f%C3%B3rmula%20r%C3%A1pida%20que%20se%20puede%20usar%20para%20comparar%20si%20los%20valores%20de%20la%20columna%20seleccionada%20son%20los%20mismos%20en%20la%20fila%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778617%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EA%20menudo%20tengo%20el%20mismo%20problema%20y%20extra%C3%B1o%20esta%20funcionalidad.%3C%2FP%3E%3CP%3EPero%20parece%20que%20ambos%20somos%20los%20%C3%BAnicos%20que%20%22regularmente%22%20comparamos%20valores%20en%20diferentes%20columnas%20-%20y%20deseamos%20facilitar%20el%20paso.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EComo%20se%20rechazaron%20otros%20deseos%20de%20mejorar%20el%20nuevo%20men%C3%BA%20de%20columnas%20de%20f%C3%B3rmula%20(los%20desarrolladores%20quieren%20mantener%20el%20men%C3%BA%20%22delgado%22)%2C%20me%20temo%20que%20este%20tampoco%20encontrar%C3%A1%20su%20camino%20en%20JMP.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3ESin%20embargo%2C%20con%20la%20nueva%20entrada%20%3CSTRONG%3ENueva%20columna%20de%20f%C3%B3rmula%2FF%C3%B3rmula...%3C%2FSTRONG%3E%20se%20volvi%C3%B3%20mucho%20m%C3%A1s%20f%C3%A1cil%20crear%20dicha%20columna%20de%20f%C3%B3rmula%20manualmente%3A%3C%2FP%3E%3CP%3Eusa%20la%20nueva%20entrada%3C%2FP%3E%3CP%3E...%20agregue%20%3D%20y%20la%20segunda%20columna.%20hecho.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EMmm....%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1722635827650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1722635827650.png%22%20style%3D%22width%3A%20358px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1722635827650.png%22%20style%3D%22width%3A%20358px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1722635827650.png%22%20style%3D%22width%3A%20358px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66788iECACAA653681EF10%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1722635827650.png%22%20alt%3D%22hogi_0-1722635827650.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778626%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20Agregar%20una%20nueva%20f%C3%B3rmula%20r%C3%A1pida%20que%20se%20puede%20usar%20para%20comparar%20si%20los%20valores%20de%20la%20columna%20seleccionada%20son%20los%20mismos%20en%20la%20fila%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778626%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EAh%2C%20incluso%20envi%C3%A9%20un%20deseo%3A%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2Fnew-formula-column-equals%2Fm-p%2F657291%23U657291%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3Enueva%20columna%20de%20f%C3%B3rmula%3A%20es%20igual%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Desafortunadamente%3A%200%20Felicitaciones%20hasta%20ahora.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Add new quick formula which can be used to compare if selected column values are same in the row

From time to time I come across situation where I would like to quickly check if two columns have exactly same results in rows. I usually do this by writing new column with :COL1 == COL2 for example. It would be nice to have this as an New Formula option in right click menu (and hopefully support more than 2 columns).

3 Comments
Status changed to: Acknowledged

Hi @jthi, thank you for taking the time to submit this idea! We will review your request and keep you updated on its status. 

hogi
Level XII

I often have the same issue - and miss this functionality.

But seems that the both of us are the only ones who "regularly" compare values in different columns - and have the wish to facilitate the step.

 

As other wishes to improve the new formula column menu got rejected (developers want to keep the menu "slim") , I fear that this one won't find it's way into JMP either.

 

Nevertheless, with the new New Formula column/Formula ... entry it got significantly easier to create such a formula column manually:

use the new entry

... add = and the second column. done.

 

Hm ....

 

hogi_0-1722635827650.png

 

hogi
Level XII

Ah, I even submitted a wish:
new formula column: equals 

unfortunately: 0 Kudos up to now.