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%3EGestione%20delle%20righe%2Fcolonne%20nascoste%2Fescluse%20nella%20gestione%20delle%20tabelle%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-611402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ECiao%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuando%20si%20utilizzano%20i%20comandi%20di%20elaborazione%20tabella%2C%20sarebbe%20utile%20fornire%20caselle%20di%20controllo%20nella%20finestra%20di%20dialogo%20per%20determinare%20come%20gestire%20righe%20o%20colonne%20nascoste%2Fescluse.%20In%20particolare%2C%20questo%20%C3%A8%20problematico%20con%20la%20suddivisione%20delle%20tabelle.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaluti%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%3EMiscelazione%20e%20pulizia%20dei%20dati%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%3EOggetto%3A%20gestione%20di%20righe%2Fcolonne%20nascoste%2Fescluse%20nella%20gestione%20delle%20tabelle%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-618980%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EMi%20piace%2C%20vorrei%20anche%20aggiungere%20una%20casella%20di%20controllo%20per%20utilizzare%20solo%20i%20dati%20selezionati%2C%20in%20questo%20modo%20non%20%C3%A8%20necessario%20eseguire%20il%20subset%20e%20quindi%20dividere%20dalla%20nuova%20tabella.%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%20Gestione%20di%20righe%2Fcolonne%20nascoste%2Fescluse%20nella%20gestione%20delle%20tabelle%20-%20Stato%20modificato%20in%3A%20Richiede%20informazioni%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-620922%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGrazie%20per%20questo%20suggerimento.%20Puoi%20fornire%20ulteriori%20informazioni%20su%20ci%C3%B2%20che%20vorresti%20vedere%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%3EOggetto%3A%20gestione%20di%20righe%2Fcolonne%20nascoste%2Fescluse%20nella%20gestione%20delle%20tabelle%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-631634%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ECiao%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVorrei%20avere%20un'opzione%20di%20dialogo%20per%20scegliere%20se%20includere%20righe%20nascoste%2Fescluse%20nella%20tabella%20di%20output%20quando%20si%20esegue%20una%20tabella%20divisa.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20una%20nota%20correlata%2C%20vorrei%20richiedere%20la%20disponibilit%C3%A0%20della%20stessa%20opzione%20durante%20l'esportazione%20da%20JMP%20in%20un%20altro%20formato.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaluti%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%3EOggetto%3A%20gestione%20di%20righe%2Fcolonne%20nascoste%2Fescluse%20nella%20gestione%20delle%20tabelle%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%20ha%20scritto%3A%3CBR%20%2F%3E%3CP%3EAlternativa%3A%3C%2FP%3E%0A%3CP%3Esi%20prega%20di%20aggiungere%20un'opzione%20per%20memorizzare%20lo%20stato%20escluso%20in%20una%20colonna%20aggiuntiva%20(pi%C3%B9%20colonne%20in%20caso%20di%20suddivisione).%3C%2FP%3E%0A%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3EDare%20un'occhiata%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%20Colonne%20Stato%20riga%3C%2FA%3E%20.%20Fanno%20proprio%20questo%3A%20memorizzano%20gli%20stati%20delle%20righe%20in%20una%20colonna.%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%3EOggetto%3A%20gestione%20di%20righe%2Fcolonne%20nascoste%2Fescluse%20nella%20gestione%20delle%20tabelle%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644812%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ECIAO%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%3Efantastico%20che%20questa%20funzione%20sia%20gi%C3%A0%20disponibile%20-%20non%20l'ho%20trovata.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuale%20opzione%20indica%20a%20Tables%2FSplit%20di%20mappare%20gli%20stati%20delle%20righe%20della%20tabella%20di%20input%20alle%20colonne%20dello%20stato%20delle%20righe%20nella%20tabella%20di%20output%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%3ERi%3A%20Gestione%20di%20righe%2Fcolonne%20nascoste%2Fescluse%20nella%20gestione%20delle%20tabelle%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644408%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EChe%20idea%20geniale%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%20Se%20c'%C3%A8%20una%20buona%20ragione%20per%20cui%3CSTRONG%3E%20riepilogo%3C%2FSTRONG%3E%20rispetto%20escluso%20-%20potrebbe%20esserci%20un%20motivo%20simile%20per%20cui%20anche%20le%20altre%20piattaforme%20dovrebbero%20rispettarlo%20(almeno%20per%20alcuni%20casi).%3C%2FP%3E%3CP%3ESe%20c'%C3%A8%20una%20buona%20ragione%20per%20cui%20una%20piattaforma%20non%20rispetta%20gli%20esclusi%2C%20potrebbe%20esserci%20una%20ragione%20simile%3CSTRONG%3E%20riepilogo%3C%2FSTRONG%3E%20non%20dovrebbe%20neanche%20(almeno%20per%20alcuni%20casi).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ES%C3%8C%2C%3CBR%20%2F%3E%20per%20favore%20aggiungi%20un%20s%C3%AC%2Fno%20%26gt%3Bopzione%26lt%3B%20a%3CSTRONG%3E%20TUTTO%3C%2FSTRONG%3E%20Piattaforme%20da%20tavolo%3CBR%20%2F%3E%20...%20A%3CSTRONG%3E%20rispetto%20escluso%3C%2FSTRONG%3E%20(per%20suddivisione%2C%20stack%2C%20aggiornamento...)%3CBR%20%2F%3E%20...%20e%20se%20lo%20desideri%3A%20disabilitarlo%20per%20riepilogo%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%3Eaggiungere%20un'opzione%20per%20memorizzare%20lo%20stato%20escluso%20in%20una%20colonna%20aggiuntiva%20(molte%20colonne%20in%20caso%20di%20suddivisione).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternativa%3A%3C%2FP%3E%3CP%3ESi%20prega%20di%20aggiungere%20un%20avvertimento%20che%20la%20rispettiva%20piattaforma%20tabella%20%C3%A8%20una%20di%20quelle%20ignorate%20escluse%3CBR%20%2F%3E%20(ad%20esempio%20come%20opzione%20nella%20piattaforma%3A%20%22rispetto%20escluso%22%20-%20un'opzione%20disabilitata%3CBR%20%2F%3E%20oppure%3A%20come%20testo%20di%20stato%20in%20basso%20a%20sinistra)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%C3%88%20chiaro%20che%20l'utente%20deve%20solo%20generare%20un%20sottoinsieme%20della%20riga%20non%20esclusa.%3CBR%20%2F%3E%20COS%C3%8C%20...%3CBR%20%2F%3E%3CSTRONG%3E%20Perch%C3%A9%20questa%20idea%20%C3%A8%20importante%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20causa%20del%20collegamento%20delle%20tabelle%2C%20l'utente%20riceve%20un%20feedback%20visivo%20che%20le%20tabelle%2Friepilogo%20rispettano%20%22esclusi%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%3EQuindi%2C%20non%20%C3%A8%20ovvio%20che%20le%20altre%20piattaforme%20ignorino%20%22escluso%22%20ed%20%C3%A8%20difficile%20trovare%20queste%20informazioni%20nella%20documentazione.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-702885%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERi%3A%20Gestione%20di%20righe%2Fcolonne%20nascoste%2Fescluse%20nella%20gestione%20delle%20tabelle%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-702885%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Eaggiunto%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%20Piccole%20trappole%20in%20Jmp%20e%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