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%3EUmgang%20mit%20ausgeblendeten%20%2F%20ausgeschlossenen%20Zeilen%20%2F%20Spalten%20bei%20der%20Tabellenbehandlung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-611402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHallo%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBei%20Verwendung%20der%20Tabellenverarbeitungsbefehle%20w%C3%A4re%20es%20hilfreich%2C%20Kontrollk%C3%A4stchen%20im%20Dialogfeld%20bereitzustellen%2C%20um%20festzulegen%2C%20wie%20mit%20ausgeblendeten%20%2F%20ausgeschlossenen%20Zeilen%20oder%20Spalten%20umgegangen%20werden%20soll.%20Dies%20ist%20insbesondere%20beim%20Splitten%20von%20Tabellen%20problematisch.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGr%C3%BC%C3%9Fe%3C%2FP%3E%3CP%3EMeul%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%3EDatenverschmelzung%20und%20-bereinigung%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%3EBetreff%3A%20Umgang%20mit%20ausgeblendeten%20%2F%20ausgeschlossenen%20Zeilen%20%2F%20Spalten%20in%20der%20Tabellenbehandlung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-618980%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EIch%20mag%20das%2C%20ich%20m%C3%B6chte%20auch%20ein%20Kontrollk%C3%A4stchen%20hinzuf%C3%BCgen%2C%20um%20nur%20ausgew%C3%A4hlte%20Daten%20zu%20verwenden%2C%20damit%20Sie%20keine%20Teilmengen%20und%20dann%20von%20der%20neuen%20Tabelle%20trennen%20m%C3%BCssen.%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%3EBetreff%3A%20Umgang%20mit%20ausgeblendeten%2Fausgeschlossenen%20Zeilen%2FSpalten%20in%20der%20Tabellenbehandlung%20-%20Status%20ge%C3%A4ndert%20in%3A%20Needs%20Info%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-620922%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EVielen%20Dank%20f%C3%BCr%20diesen%20Vorschlag.%20K%C3%B6nnen%20Sie%20bitte%20zus%C3%A4tzliche%20Informationen%20dar%C3%BCber%20geben%2C%20was%20Sie%20sehen%20m%C3%B6chten%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%3EBetreff%3A%20Umgang%20mit%20ausgeblendeten%2Fausgeschlossenen%20Zeilen%2FSpalten%20bei%20der%20Tabellenverarbeitung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-631634%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHallo%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIch%20h%C3%A4tte%20gerne%20eine%20Dialogoption%2C%20mit%20der%20ich%20ausw%C3%A4hlen%20kann%2C%20ob%20bei%20der%20Erstellung%20einer%20geteilten%20Tabelle%20ausgeblendete%2Fausgeschlossene%20Zeilen%20in%20die%20Ausgabetabelle%20einbezogen%20werden%20sollen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20diesem%20Zusammenhang%20m%C3%B6chte%20ich%20die%20Verf%C3%BCgbarkeit%20derselben%20Option%20anfordern%2C%20wenn%20ich%20einen%20Export%20aus%20JMP%20in%20ein%20anderes%20Format%20durchf%C3%BChre.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGr%C3%BC%C3%9Fe%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%3EBetreff%3A%20Umgang%20mit%20ausgeblendeten%2Fausgeschlossenen%20Zeilen%2FSpalten%20bei%20der%20Tabellenverarbeitung%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%20schrieb%3A%3CBR%20%2F%3E%3CP%3EAlternative%3A%3C%2FP%3E%0A%3CP%3EBitte%20f%C3%BCgen%20Sie%20eine%20Option%20hinzu%2C%20um%20den%20ausgeschlossenen%20Status%20in%20einer%20zus%C3%A4tzlichen%20Spalte%20zu%20speichern%20(viele%20Spalten%20im%20Falle%20einer%20Aufteilung).%3C%2FP%3E%0A%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3ESchauen%20Sie%20mal%20rein%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%20Zeilenstatusspalten%3C%2FA%3E%20.%20Sie%20tun%20genau%20das%3A%20Zeilenzust%C3%A4nde%20in%20einer%20Spalte%20speichern.%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%3EBetreff%3A%20Umgang%20mit%20ausgeblendeten%2Fausgeschlossenen%20Zeilen%2FSpalten%20bei%20der%20Tabellenverarbeitung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644812%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHallo%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%3ESch%C3%B6n%2C%20dass%20es%20diese%20Funktion%20bereits%20gibt%20%E2%80%93%20ich%20habe%20sie%20nicht%20gefunden.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWelche%20Option%20weist%20Tables%2FSplit%20an%2C%20die%20Zeilenzust%C3%A4nde%20der%20Eingabetabelle%20den%20Zeilenzustandsspalten%20in%20der%20Ausgabetabelle%20zuzuordnen%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%3EBetreff%3A%20Umgang%20mit%20ausgeblendeten%2Fausgeschlossenen%20Zeilen%2FSpalten%20bei%20der%20Tabellenverarbeitung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644408%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EWas%20f%C3%BCr%20eine%20geniale%20Idee%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%20Wenn%20es%20einen%20guten%20Grund%20daf%C3%BCr%20gibt%3CSTRONG%3E%20Zusammenfassung%3C%2FSTRONG%3E%20Respekt%20ausgeschlossen%20%E2%80%93%20es%20k%C3%B6nnte%20einen%20%C3%A4hnlichen%20Grund%20geben%2C%20warum%20die%20anderen%20Plattformen%20dies%20ebenfalls%20respektieren%20sollten%20(zumindest%20in%20einigen%20F%C3%A4llen).%3C%2FP%3E%3CP%3EWenn%20es%20einen%20guten%20Grund%20gibt%2C%20warum%20eine%20Plattform%20Ausgeschlossenes%20nicht%20respektiert%2C%20k%C3%B6nnte%20es%20einen%20%C3%A4hnlichen%20Grund%20daf%C3%BCr%20geben%3CSTRONG%3E%20Zusammenfassung%3C%2FSTRONG%3E%20sollte%20es%20auch%20nicht%20tun%20(zumindest%20in%20manchen%20F%C3%A4llen).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJa%2C%3CBR%20%2F%3E%20Bitte%20f%C3%BCgen%20Sie%20eine%20Ja%2FNein%20%26gt%3BOption%26lt%3B%20hinzu%3CSTRONG%3E%20ALLE%3C%2FSTRONG%3E%20Tischplattformen%3CBR%20%2F%3E%20...%20Zu%3CSTRONG%3E%20Respekt%20ausgeschlossen%3C%2FSTRONG%3E%20(f%C3%BCr%20Split%2C%20Stack%2C%20Update%20...)%3CBR%20%2F%3E%20...%20und%20wenn%20Sie%20m%C3%B6chten%3A%20zur%20Zusammenfassung%20deaktivieren%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%3EBitte%20f%C3%BCgen%20Sie%20eine%20Option%20hinzu%2C%20um%20den%20ausgeschlossenen%20Status%20in%20einer%20zus%C3%A4tzlichen%20Spalte%20zu%20speichern%20(viele%20Spalten%20im%20Falle%20einer%20Aufteilung).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternative%3A%3C%2FP%3E%3CP%3EBitte%20f%C3%BCgen%20Sie%20eine%20Warnung%20hinzu%2C%20dass%20die%20jeweilige%20Tabellenplattform%20zu%20denen%20geh%C3%B6rt%2C%20die%20ausgeschlossene%20Plattformen%20ignorieren%3CBR%20%2F%3E%20(z.%20B.%20als%20Option%20in%20der%20Plattform%3A%20%E2%80%9ERespekt%20ausgeschlossen%E2%80%9C%20%E2%80%93%20eine%20Option%2C%20die%20deaktiviert%20ist%3CBR%20%2F%3E%20oder%3A%20als%20Statustext%20unten%20links)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EEs%20ist%20klar%2C%20dass%20der%20Benutzer%20lediglich%20eine%20Teilmenge%20der%20nicht%20ausgeschlossenen%20Zeile%20generieren%20muss.%3CBR%20%2F%3E%20Also%20...%3CBR%20%2F%3E%3CSTRONG%3E%20Warum%20ist%20diese%20Idee%20wichtig%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAufgrund%20der%20Tabellenverkn%C3%BCpfung%20erh%C3%A4lt%20der%20Benutzer%20eine%20visuelle%20R%C3%BCckmeldung%2C%20dass%20Tabellen%2FZusammenfassung%20%E2%80%9Eausgeschlossen%E2%80%9C%20ber%C3%BCcksichtigt%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%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%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDaher%20ist%20es%20nicht%20offensichtlich%2C%20dass%20die%20anderen%20Plattformen%20%E2%80%9Eausgeschlossen%E2%80%9C%20ignorieren%20%E2%80%93%20und%20es%20ist%20schwierig%2C%20diese%20Informationen%20in%20der%20Dokumentation%20zu%20finden.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-702885%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Umgang%20mit%20ausgeblendeten%2Fausgeschlossenen%20Zeilen%2FSpalten%20bei%20der%20Tabellenverarbeitung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-702885%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Ehinzugef%C3%BCgt%20zu%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%20Winzige%20Fallen%20in%20Jmp%20und%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