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%3EGestion%20des%20lignes%2Fcolonnes%20masqu%C3%A9es%2Fexclues%20dans%20la%20gestion%20des%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-611402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EBonjour%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELors%20de%20l'utilisation%20des%20commandes%20de%20traitement%20de%20table%2C%20il%20serait%20utile%20de%20fournir%20des%20cases%20%C3%A0%20cocher%20dans%20la%20bo%C3%AEte%20de%20dialogue%20pour%20d%C3%A9terminer%20comment%20g%C3%A9rer%20les%20lignes%20ou%20les%20colonnes%20masqu%C3%A9es%2Fexclues.%20En%20particulier%2C%20cela%20est%20probl%C3%A9matique%20avec%20le%20fractionnement%20des%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESalutations%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%3EFusion%20et%20nettoyage%20des%20donn%C3%A9es%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%26nbsp%3B%3A%20Gestion%20des%20lignes%20%2F%20colonnes%20masqu%C3%A9es%20%2F%20exclues%20dans%20la%20gestion%20des%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-618980%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJ'aime%20cela%2C%20je%20voudrais%20%C3%A9galement%20ajouter%20une%20case%20%C3%A0%20cocher%20pour%20utiliser%20uniquement%20les%20donn%C3%A9es%20s%C3%A9lectionn%C3%A9es%2C%20de%20cette%20fa%C3%A7on%2C%20vous%20n'avez%20pas%20besoin%20de%20sous-ensemble%20puis%20de%20vous%20s%C3%A9parer%20de%20la%20nouvelle%20table.%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%3EObjet%26nbsp%3B%3A%20Gestion%20des%20lignes%2Fcolonnes%20masqu%C3%A9es%2Fexclues%20dans%20la%20gestion%20des%20tableaux%20-%20Statut%20modifi%C3%A9%20en%26nbsp%3B%3A%20Besoin%20d'informations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-620922%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EMerci%20pour%20cette%20suggestion.%20Pouvez-vous%20s'il%20vous%20pla%C3%AEt%20fournir%20des%20informations%20suppl%C3%A9mentaires%20sur%20ce%20que%20vous%20aimeriez%20voir%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%26nbsp%3B%3A%20Gestion%20des%20lignes%20%2F%20colonnes%20masqu%C3%A9es%20%2F%20exclues%20dans%20la%20gestion%20des%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-631634%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EBonjour%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJ'aimerais%20avoir%20une%20option%20de%20dialogue%20pour%20choisir%20d'inclure%20ou%20non%20des%20lignes%20masqu%C3%A9es%2Fexclues%20dans%20la%20table%20de%20sortie%20lors%20de%20la%20cr%C3%A9ation%20d'une%20table%20fractionn%C3%A9e.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESur%20une%20note%20connexe%2C%20je%20voudrais%20demander%20la%20disponibilit%C3%A9%20de%20la%20m%C3%AAme%20option%20lors%20d'une%20exportation%20de%20JMP%20vers%20un%20autre%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESalutations%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%26nbsp%3B%3A%20Gestion%20des%20lignes%20%2F%20colonnes%20masqu%C3%A9es%20%2F%20exclues%20dans%20la%20gestion%20des%20tables%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%20%C3%A9crit%3A%3CBR%20%2F%3E%3CP%3EAlternative%3A%3C%2FP%3E%0A%3CP%3Eveuillez%20ajouter%20une%20option%20pour%20stocker%20l'%C3%A9tat%20exclu%20dans%20une%20colonne%20suppl%C3%A9mentaire%20(plusieurs%20colonnes%20en%20cas%20de%20fractionnement).%3C%2FP%3E%0A%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3EJeter%20un%20coup%20d'%C5%93il%20%C3%A0%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%20Colonnes%20d'%C3%A9tat%20de%20ligne%3C%2FA%3E%20.%20C'est%20exactement%20ce%20qu'ils%20font%26nbsp%3B%3A%20stocker%20les%20%C3%A9tats%20des%20lignes%20dans%20une%20colonne.%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%26nbsp%3B%3A%20Gestion%20des%20lignes%20%2F%20colonnes%20masqu%C3%A9es%20%2F%20exclues%20dans%20la%20gestion%20des%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644812%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESalut%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%3Esuper%20que%20cette%20fonctionnalit%C3%A9%20soit%20d%C3%A9j%C3%A0%20disponible%20-%20je%20ne%20l'ai%20pas%20trouv%C3%A9e.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuelle%20option%20indique%20%C3%A0%20Tables%2FSplit%20de%20mapper%20les%20%C3%A9tats%20de%20ligne%20de%20la%20table%20d'entr%C3%A9e%20aux%20colonnes%20d'%C3%A9tat%20de%20ligne%20dans%20la%20table%20de%20sortie%26nbsp%3B%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%20%3A%20Gestion%20des%20lignes%2Fcolonnes%20masqu%C3%A9es%2Fexclues%20dans%20la%20gestion%20des%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644408%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EQuelle%20id%C3%A9e%20g%C3%A9niale%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%20S'il%20y%20a%20une%20bonne%20raison%20%C3%A0%20cela%3CSTRONG%3E%20r%C3%A9sum%C3%A9%3C%2FSTRONG%3E%20respects%20exclus%20-%20il%20pourrait%20y%20avoir%20une%20raison%20similaire%20pour%20laquelle%20les%20autres%20plates-formes%20devraient%20%C3%A9galement%20le%20respecter%20(au%20moins%20dans%20certains%20cas).%3C%2FP%3E%3CP%3ES'il%20existe%20une%20bonne%20raison%20pour%20laquelle%20une%20plateforme%20ne%20respecte%20pas%20les%20exclusions%2C%20il%20pourrait%20y%20avoir%20une%20raison%20similaire%20pour%20laquelle%3CSTRONG%3E%20r%C3%A9sum%C3%A9%3C%2FSTRONG%3E%20ne%20devrait%20pas%20non%20plus%20(au%20moins%20dans%20certains%20cas).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOui%2C%3CBR%20%2F%3E%20veuillez%20ajouter%20une%20%26gt%3Boption%26lt%3B%20oui%2Fnon%20%C3%A0%3CSTRONG%3E%20TOUS%3C%2FSTRONG%3E%20Plateformes%20de%20tables%3CBR%20%2F%3E%20...%20%C3%A0%3CSTRONG%3E%20respect%20exclu%3C%2FSTRONG%3E%20(pour%20split%2C%20stack%2C%20mise%20%C3%A0%20jour...)%3CBR%20%2F%3E%20...%20et%20si%20vous%20le%20souhaitez%20%3A%20le%20d%C3%A9sactiver%20pour%20r%C3%A9sum%C3%A9%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%3EAlternative%3A%3C%2FP%3E%3CP%3Eveuillez%20ajouter%20une%20option%20pour%20stocker%20l'%C3%A9tat%20exclu%20dans%20une%20colonne%20suppl%C3%A9mentaire%20(plusieurs%20colonnes%20en%20cas%20de%20fractionnement).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternative%3A%3C%2FP%3E%3CP%3EVeuillez%20ajouter%20un%20avertissement%20indiquant%20que%20la%20plate-forme%20de%20table%20concern%C3%A9e%20fait%20partie%20de%20celles%20qui%20ignorent%20les%20exclusions.%3CBR%20%2F%3E%20(par%20exemple%20en%20option%20dans%20la%20plateforme%20%3A%20%22respect%20exclu%22%20-%20une%20option%20qui%20est%20d%C3%A9sactiv%C3%A9e%3CBR%20%2F%3E%20ou%26nbsp%3B%3A%20comme%20texte%20d'%C3%A9tat%20en%20bas%20%C3%A0%20gauche)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIl%20est%20clair%20que%20l'utilisateur%20doit%20simplement%20g%C3%A9n%C3%A9rer%20un%20sous-ensemble%20de%20la%20ligne%20non%20exclue.%3CBR%20%2F%3E%20donc%20...%3CBR%20%2F%3E%3CSTRONG%3E%20Pourquoi%20cette%20id%C3%A9e%20est-elle%20importante%20%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEn%20raison%20de%20la%20liaison%20des%20tables%2C%20l'utilisateur%20obtient%20un%20retour%20visuel%20indiquant%20que%20les%20tableaux%2Fr%C3%A9sum%C3%A9s%20respectent%20%22exclus%22%26nbsp%3B%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%3EIl%20n'est%20donc%20pas%20%C3%A9vident%20que%20les%20autres%20plateformes%20ignorent%20les%20%22exclus%22%20-%20et%20il%20est%20difficile%20de%20trouver%20cette%20information%20dans%20la%20Documentation.%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%20%3A%20Gestion%20des%20lignes%2Fcolonnes%20masqu%C3%A9es%2Fexclues%20dans%20la%20gestion%20des%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-702885%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Eajout%C3%A9%20%C3%A0%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%20Petits%20pi%C3%A8ges%20dans%20Jmp%20et%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