cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-611402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EManejo%20de%20filas%20%2F%20columnas%20ocultas%20%2F%20excluidas%20en%20el%20manejo%20de%20tablas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-611402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHola%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAl%20usar%20los%20comandos%20de%20procesamiento%20de%20tablas%2C%20ser%C3%ADa%20%C3%BAtil%20proporcionar%20casillas%20de%20verificaci%C3%B3n%20en%20el%20cuadro%20de%20di%C3%A1logo%20para%20determinar%20c%C3%B3mo%20manejar%20filas%20o%20columnas%20ocultas%2Fexcluidas.%20En%20particular%2C%20esto%20es%20problem%C3%A1tico%20con%20la%20divisi%C3%B3n%20de%20tablas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaludos%3C%2FP%3E%3CP%3EMehul%20Shroff%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-611402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EFusi%C3%B3n%20y%20limpieza%20de%20datos%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-618980%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Manejo%20de%20filas%2Fcolumnas%20ocultas%2Fexcluidas%20en%20el%20manejo%20de%20tablas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-618980%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EMe%20gusta%20esto%2C%20tambi%C3%A9n%20me%20gustar%C3%ADa%20agregar%20una%20casilla%20de%20verificaci%C3%B3n%20para%20usar%20solo%20los%20datos%20seleccionados%2C%20de%20esa%20manera%20no%20tiene%20que%20subdividir%20y%20luego%20dividir%20de%20la%20nueva%20tabla.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteve%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-620922%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Manejo%20de%20filas%20%2F%20columnas%20ocultas%20%2F%20excluidas%20en%20el%20manejo%20de%20tablas%20-%20Estado%20cambiado%20a%3A%20Necesita%20informaci%C3%B3n%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-620922%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGracias%20por%20esta%20sugerencia.%20%C2%BFPuede%20proporcionar%20informaci%C3%B3n%20adicional%20sobre%20lo%20que%20le%20gustar%C3%ADa%20ver%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-631634%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Manejo%20de%20filas%2Fcolumnas%20ocultas%2Fexcluidas%20en%20el%20manejo%20de%20tablas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-631634%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHola%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMe%20gustar%C3%ADa%20tener%20una%20opci%C3%B3n%20de%20di%C3%A1logo%20para%20elegir%20si%20incluir%20filas%20ocultas%2Fexcluidas%20en%20la%20tabla%20de%20salida%20al%20hacer%20una%20tabla%20dividida.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEn%20una%20nota%20relacionada%2C%20me%20gustar%C3%ADa%20solicitar%20la%20disponibilidad%20de%20la%20misma%20opci%C3%B3n%20al%20realizar%20una%20exportaci%C3%B3n%20desde%20JMP%20a%20otro%20formato.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaludos%3C%2FP%3E%3CP%3EMehul%20Shroff%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644801%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Manejo%20de%20filas%2Fcolumnas%20ocultas%2Fexcluidas%20en%20el%20manejo%20de%20tablas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644801%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CBLOCKQUOTE%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26800%22%20target%3D%22_blank%22%3E%40hogi%3C%2FA%3E%20escribi%C3%B3%3A%3CBR%20%2F%3E%3CP%3EAlternativa%3A%3C%2FP%3E%0A%3CP%3Eagregue%20una%20opci%C3%B3n%20para%20almacenar%20el%20estado%20excluido%20en%20una%20columna%20adicional%20(muchas%20columnas%20en%20el%20caso%20de%20divisi%C3%B3n).%3C%2FP%3E%0A%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3EEcha%20un%20vistazo%20a%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F17.1%2Findex.shtml%23page%2Fjmp%2Fstore-information-in-row-state-columns.shtml%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%20Columnas%20de%20estado%20de%20fila%3C%2FA%3E%20.%20Hacen%20exactamente%20eso%3A%20almacenar%20estados%20de%20fila%20en%20una%20columna.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644812%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Manejo%20de%20filas%2Fcolumnas%20ocultas%2Fexcluidas%20en%20el%20manejo%20de%20tablas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644812%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%2F6878%22%20target%3D%22_blank%22%3E%20%40Jeff_Perkinson%3C%2FA%3E%3C%2FP%3E%3CP%3EGenial%20que%20esta%20funci%C3%B3n%20ya%20est%C3%A9%20disponible%2C%20no%20la%20encontr%C3%A9.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%C2%BFQu%C3%A9%20opci%C3%B3n%20le%20dice%20a%20Tables%2FSplit%20que%20asigne%20los%20estados%20de%20fila%20de%20la%20tabla%20de%20entrada%20a%20las%20columnas%20de%20estado%20de%20fila%20en%20la%20tabla%20de%20salida%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644408%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Manejo%20de%20filas%2Fcolumnas%20ocultas%2Fexcluidas%20en%20el%20manejo%20de%20tablas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644408%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EQue%20idea%20tan%20brillante%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Acara_con_una_leve_sonrisa%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Si%20hay%20una%20buena%20raz%C3%B3n%20por%20la%20cual%3CSTRONG%3E%20resumen%3C%2FSTRONG%3E%20respetos%20excluidos%3A%20podr%C3%ADa%20haber%20una%20raz%C3%B3n%20similar%20por%20la%20que%20las%20otras%20plataformas%20tambi%C3%A9n%20deber%C3%ADan%20respetarlo%20(al%20menos%20en%20algunos%20casos).%3C%2FP%3E%3CP%3ESi%20hay%20una%20buena%20raz%C3%B3n%20por%20la%20cual%20una%20plataforma%20no%20respeta%20los%20excluidos%2C%20podr%C3%ADa%20haber%20una%20raz%C3%B3n%20similar%20por%20la%20cual%3CSTRONG%3E%20resumen%3C%2FSTRONG%3E%20Tampoco%20deber%C3%ADa%20(al%20menos%20en%20algunos%20casos).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ES%C3%AD%2C%3CBR%20%2F%3E%20por%20favor%20agregue%20una%20%26gt%3Bopci%C3%B3n%26lt%3B%20s%C3%AD%2Fno%20a%3CSTRONG%3E%20TODO%3C%2FSTRONG%3E%20Plataformas%20de%20mesa%3CBR%20%2F%3E%20...%20a%3CSTRONG%3E%20respeto%20excluido%3C%2FSTRONG%3E%20(para%20dividir%2C%20apilar%2C%20actualizar...)%3CBR%20%2F%3E%20...%20y%20si%20lo%20deseas%3A%20desactivarlo%20para%20resumen%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Acara_con_una_leve_sonrisa%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternativa%3A%3C%2FP%3E%3CP%3Eagregue%20una%20opci%C3%B3n%20para%20almacenar%20el%20estado%20excluido%20en%20una%20columna%20adicional%20(muchas%20columnas%20en%20el%20caso%20de%20divisi%C3%B3n).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternativa%3A%3C%2FP%3E%3CP%3EAgregue%20una%20advertencia%20de%20que%20la%20plataforma%20de%20mesa%20respectiva%20es%20una%20de%20las%20que%20ignoran%20las%20excluidas.%3CBR%20%2F%3E%20(por%20ejemplo%2C%20como%20opci%C3%B3n%20en%20la%20plataforma%3A%20%22respeto%20excluido%22%20-%20opci%C3%B3n%20que%20est%C3%A1%20deshabilitada%3CBR%20%2F%3E%20o%3A%20como%20texto%20de%20estado%20en%20la%20parte%20inferior%20izquierda)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EEst%C3%A1%20claro%20que%20el%20usuario%20s%C3%B3lo%20tiene%20que%20generar%20un%20subconjunto%20de%20la%20fila%20no%20excluida.%3CBR%20%2F%3E%20entonces%20...%3CBR%20%2F%3E%3CSTRONG%3E%20%C2%BFPor%20qu%C3%A9%20es%20importante%20esta%20idea%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDebido%20a%20la%20vinculaci%C3%B3n%20de%20tablas%2C%20el%20usuario%20recibe%20una%20respuesta%20visual%20de%20que%20las%20Tablas%2FResumen%20respetan%20los%20%22excluidos%22%3A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ECurrent%20Data%20Table()%20%26lt%3B%26lt%3B%20Data%20Filter(%0AAdd%20Filter(%0Acolumns(%20%3Aage%20)%2C%0AWhere(%20%3Aage%20%3D%3D%20%7B14%2C%2017%7D%20)%0A))%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1687316808898.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F53982i209777C40DF4646C%2Fimage-dimensions%2F271x345%3Fv%3Dv2%22%20width%3D%22271%22%20height%3D%22345%22%20role%3D%22button%22%20title%3D%22hogi_0-1687316808898.png%22%20alt%3D%22hogi_0-1687316808898.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPor%20lo%20tanto%2C%20no%20es%20obvio%20que%20las%20otras%20plataformas%20ignoren%20%22excluido%22%2C%20y%20es%20dif%C3%ADcil%20encontrar%20esta%20informaci%C3%B3n%20en%20la%20Documentaci%C3%B3n.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-702885%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Manejo%20de%20filas%2Fcolumnas%20ocultas%2Fexcluidas%20en%20el%20manejo%20de%20tablas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-702885%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Ea%C3%B1adido%20a%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FTiny-Traps-in-Jmp-and-JSL%2Fm-p%2F702685%23U702685%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-forum-thread%20lia-fa-icon%20lia-fa-forum%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%20Peque%C3%B1as%20trampas%20en%20Jmp%20y%20JSL%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Handling Hidden / Excluded rows / columns in Table-handling

Hello,

 

When using the Table-processing commands, it would be helpful to provide checkboxes in the dialog to determine how to handle hidden / excluded rows or columns. In particular, this is problematic with splitting tables.

 

Regards

Mehul Shroff

7 Comments
shampton82
Level VII

I like this, I would also like to add in a check box for using only selected data, that way you don't have to subset then split from the new table.

 

Steve

mia_stephens
Staff
Status changed to: Needs Info

Thank you for this suggestion. Can you please provide additional information on what you would like to see?

MShroff
Level V

Hello,

 

I would like to have a dialog option to choose whether to include hidden / excluded rows in the output table when doing a Split Table.

 

On a related note, I would like to request the availability of the same option when doing an export from JMP into another format.

 

Regards

Mehul Shroff

hogi
Level XI

What a brilliant idea

If there is a good reason why summary respects excluded - there could be a similar reason why the other platforms should respect it as well (at least for some cases).

If there is a good reason why a platform doesn't respect excluded - there could be a similar reason why summary shouldn't either (at least for some cases).

 

Yes, 
please add a yes/no  >option< to ALL Table platforms 
...  to respect excluded  (for split, stack, update ...)
... and if you wish: to disable it for summary

 

Alternative: 

please add an option to store the excluded state in an additional column (many column in the case of split).

 

Alternative: 

Please add a warning that the respective Table Platform is one of those which ignore excluded
(e.g. as a option in the platform: "respect excluded" - an option which is disabled
or: as status text on the bottom left)


It's clear that the user just has to generate a subset of the non-excluded row.
so ...
Why is this idea important? 

 

Due to table linking - the user gets a visual feedback that Tables/Summary does respect "excluded":

Current Data Table() << Data Filter(
Add Filter(
columns( :age ),
Where( :age == {14, 17} )
));

 

hogi_0-1687316808898.png

 

So, it's not obvious that the other platforms ignore "excluded" - and it's hard to find this info in the Documentation.

Jeff_Perkinson
Community Manager
@hogi wrote:

Alternative: 

please add an option to store the excluded state in an additional column (many column in the case of split).


Take a look at Row State columns. They do just that: store row states in a column.

 

 

hogi
Level XI

Hi @Jeff_Perkinson 

great that this feature is already available - I didn't find it.

 

Which option tells Tables/Split so map the row states of the the input table to row state columns in the output table?

hogi
Level XI