cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-692118%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ELassen%20Sie%20uns%20f%C3%BCr%20Tabellenvariablen%20kompliziertere%20Datentypen%20als%20nur%20Text%20und%20Zahlen%20verwenden%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692118%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CSTRONG%3EWas%20hat%20diese%20Wunschlistenanfrage%20inspiriert%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ETabellenvariablen%20sind%20ein%20guter%20Ort%20zum%20Speichern%20von%20Informationen%2C%20auf%20die%20Benutzer%20dann%20als%20Tabellenvariable%20zugreifen%20oder%20sie%20in%20Formeln%20verwenden%20k%C3%B6nnen.%20Derzeit%20sind%20wir%20auf%20Text-%20und%20numerische%20Werte%20beschr%C3%A4nkt%2C%20was%20die%20Verwendung%20einschr%C3%A4nkt%20und%20Problemumgehungen%20erfordert%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2Fsave-matrix-as-table-variable%2Fm-p%2F691581%23U691581%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%3EMatrix%20als%20Tabellenvariable%20speichern%3F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EWelche%20Verbesserung%20w%C3%BCrden%20Sie%20sich%20w%C3%BCnschen%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EIch%20m%C3%B6chte%2C%20dass%20Tabellenvariablen%20alle%20JMP-Datentypen%20unterst%C3%BCtzen%20(oder%20zumindest%20Listen%2C%20Matrizen%20und%20assoziative%20Arrays).%20Derzeit%20m%C3%BCssen%20wir%20eine%20Problemumgehung%20verwenden%2C%20bei%20der%20wir%20diese%20in%20einen%20String%20konvertieren%20und%20dann%20mit%20Parse()%20wieder%20in%20den%20urspr%C3%BCnglichen%20Datentyp%20zur%C3%BCckkehren.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0Adt%20%26lt%3B%26lt%3B%20New%20Table%20Variable(%22Day_mat%22%2C%20Char(%5B42%2043%5D))%3B%0A%0Am%20%3D%20Parse(%3ADay_mat)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EWarum%20ist%20diese%20Idee%20wichtig%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EMacht%20Tabellenvariablen%20n%C3%BCtzlicher%2C%20ohne%20dass%20Workarounds%20verwendet%20werden%20m%C3%BCssen%2C%20die%20m%C3%B6glicherweise%20funktionieren%20oder%20auch%20nicht.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-692118%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAutomatisierung%20und%20Skripterstellung%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EInhaltsorganisation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EErgebnisse%20teilen%20und%20kommunizieren%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692617%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Lassen%20Sie%20uns%20f%C3%BCr%20Tabellenvariablen%20kompliziertere%20Datentypen%20verwenden%20als%20nur%20Text%20und%20Zahlen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692617%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EVielen%20Dank%2C%20dass%20Sie%20diesen%20Wunsch%20%C3%BCbermittelt%20haben%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.%20Ich%20m%C3%B6chte%20hinzuf%C3%BCgen%2C%20dass%20die%20bereitgestellte%20Problemumgehung%2C%20die%20Matrix%20als%20Zeichenfolge%20zu%20speichern%20(oder%20alternativ%20die%20Matrix%20als%20JSL-Tabellenskript%20zu%20speichern)%2C%20bedeutet%2C%20dass%20der%20Wert%20im%20Wesentlichen%20als%20Text%20in%20der%20Tabelle%20gespeichert%20wird.%20Bei%20sehr%20gro%C3%9Fen%20Matrizen%20habe%20ich%20bei%20beiden%20Methoden%20Bedenken%2C%20dass%20dies%20dazu%20f%C3%BChren%20k%C3%B6nnte%2C%20dass%20der%20f%C3%BCr%20jede%20Tabelle%20ben%C3%B6tigte%20Speicherplatz%20und%20die%20entsprechenden%20Lade-%2FSpeicherzeiten%20erheblich%20ansteigen.%20Ich%20habe%20nicht%20best%C3%A4tigt%2C%20ob%20das%20wirklich%20ein%20Problem%20ist%2C%20aber%20es%20erscheint%20plausibel.%20Daher%20w%C3%BCrde%20auch%20ich%20mir%20die%20M%C3%B6glichkeit%20w%C3%BCnschen%2C%20Matrizen%2C%20Listen%20und%20assoziative%20Arrays%20als%20Tabellenvariablen%20zu%20speichern.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718515%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Lassen%20Sie%20uns%20kompliziertere%20Datentypen%20f%C3%BCr%20Tabellenvariablen%20verwenden%20als%20nur%20Text%20und%20Zahlen%20%E2%80%93%20Status%20ge%C3%A4ndert%20in%3A%20Best%C3%A4tigt%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718515%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718537%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Lassen%20Sie%20uns%20f%C3%BCr%20Tabellenvariablen%20kompliziertere%20Datentypen%20als%20nur%20Text%20und%20Zahlen%20verwenden%20%E2%80%93%20Status%20ge%C3%A4ndert%20in%3A%20Wird%20untersucht%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718537%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798172%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Lassen%20Sie%20uns%20f%C3%BCr%20Tabellenvariablen%20kompliziertere%20Datentypen%20verwenden%20als%20nur%20Text%20und%20Zahlen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798172%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EAnwendungsfall%20von%20(verschachtelten)%20assoziativen%20Arrays%3A%20Speichern%20von%20Metadaten%20beim%20Verketten%20mehrerer%20Eingabedateien%3CBR%20%2F%3E%3CBR%20%2F%3E%20zugeh%C3%B6riger%20Wunsch%3A%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FGeneral-information-about-table%2Fm-p%2F706321%23U706321%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%3EAllgemeine%20Informationen%20zur%20Tabelle%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Let us use more complicated data types for table variables than just text and numbers

What inspired this wish list request? 

Table variables are nice place to store information which users can then access as table variable or use in formulas. Currently we are limited to text and numeric values which limits the usage and requires workarounds

save matrix as table variable? 

 

What is the improvement you would like to see?

I would like that Table Variables would support all JMP data types (or at least lists, matrices and associative arrays). Currently we have to use workaround where we convert these into string and then back to the original datatype using Parse()

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Table Variable("Day_mat", Char([42 43]));

m = Parse(:Day_mat);

 

Why is this idea important?

Makes table variables more useful without the requirement to use workarounds which might or might not work.

 

 

4 Comments
nikles
Level VI

Thanks for submitting this wish @jthi .  I would add that the provided workaround of saving the matrix as a string (or alternatively saving the matrix as a jsl table script), means the value is essentially being saved to the table as text.  For very large matrices, my concern with either method is that this could result in greatly increasing the disk space needed for each table, and the corresponding load/save times.  I have not confirmed if that is really an issue, but it seems plausible.  Therefore, I too would like to see the ability to save matrices, lists, and associative arrays as table variables.

Status changed to: Acknowledged
 
mia_stephens
Staff
Status changed to: Investigating
 
hogi
Level XII

application case of (nested) associative arrays: store metadata when concatenating multiple input files

related wish:
General information about table