cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-848773%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ESpalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848773%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIch%20habe%20hier%20etwas%20zu%20tun%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FAutomatically-plot-associated-columns%2Fm-p%2F755653%23M93775%22%20target%3D%22_blank%22%3EGel%C3%B6st%3A%20Zugeh%C3%B6rige%20Spalten%20automatisch%20darstellen%20-%20JMP%20User%20Community%3C%2FA%3E%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3Eaber%20ich%20bin%20mir%20ziemlich%20sicher%2C%20dass%20es%20unn%C3%B6tig%20umst%C3%A4ndlich%20ist.%20Ich%20habe%20Spaltennamen%2C%20die%20mit%20dem%20Buchstaben%20H%20(High)%20enden%2C%20die%20ich%20mit%20Spaltennamen%20verkn%C3%BCpfen%20muss%2C%20die%20ansonsten%20%C3%BCbereinstimmen%2C%20aber%20mit%20dem%20Buchstaben%20L%20(Low)%20enden.%20Ich%20kann%20ein%20assoziatives%20Array%20erstellen%2C%20wobei%20das%20letzte%20Zeichen%20der%20Spaltennamen%20entfernt%20wird.%20Ich%20wei%C3%9F%20nicht%2C%20was%20ich%20als%20N%C3%A4chstes%20tun%20soll%3F%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0Adt%20%3D%20Current%20Data%20Table()%3B%0A%0AcolList%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20string%20)%3B%0A%0Afor%20each(%7Bcol%2Cindex%7D%2C%20colList%2C%0A%09%2F%2FcolList%5Bindex%5D%20%3D%20substr(col%2C1%2C3)%0A%09colList%5Bindex%5D%20%3D%20Left(col%2CLength(col)-1)%0A)%3B%0A%0Agrps%20%3D%20associative%20array(colList)%26lt%3B%3CGET%20keys%3D%22%22%3E%3C%2FGET%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%0A%3CP%3EBeispielsweise%20muss%20VT123ABCH%20gegen%20VT123ABCL%20usw.%20dargestellt%20werden.%3C%2FP%3E%3C%2FCODE%3E%3C%2FLINGO-BODY%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CLINGO-LABS%20id%3D%22lingo-labs-848773%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EAutomatisierung%20und%20Skripting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FCODE%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848784%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848784%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3ESind%20die%20Paare%20immer%20vorhanden%3F%20Gibt%20es%20neben%20diesen%20Paaren%20noch%20weitere%20Spalten%20in%20der%20Tabelle%3F%20Stehen%20sie%20in%20einer%20bestimmten%20Reihenfolge%3F%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3EBearbeiten%3A%3C%2FP%3E%0A%3CP%3EKann%20je%20nach%20tats%C3%A4chlichem%20Anwendungsfall%20h%C3%B6chstwahrscheinlich%20deutlich%20verbessert%20werden%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0A%0Adt%20%3D%20New%20Table(%22%22%2C%0A%09New%20Column(%22VT123ABCH%22)%2C%0A%09New%20Column(%22VT123ABCL%22)%0A)%3B%0A%0Acollist%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(string)%3B%0A%0Ahcols%20%3D%20Filter%20Each(%7Bcolname%7D%2C%20colList%2C%0A%09Ends%20With(colname%2C%20%22H%22)%3B%0A)%3B%0A%0Aaa%20%3D%20Associative%20Array()%3B%0A%0AFor%20Each(%7Bhcolname%7D%2C%20hcols%2C%0A%09lcolname%20%3D%20Left(hcolname%2C%20Length(hcolname)%20-%201)%20%7C%7C%20%22L%22%3B%0A%09If(dt%20%26lt%3B%26lt%3B%20Has%20Column(lcolname)%2C%0A%09%09aa%5Bhcolname%5D%20%3D%20lcolname%0A%09)%3B%0A)%3B%0A%0AShow(aa)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848786%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848786%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHier%20ist%20ein%20Beispiel%2C%20wie%20Sie%20das%20gew%C3%BCnschte%20Ziel%20erreichen%20k%C3%B6nnen.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1742483201466.png%22%20style%3D%22width%3A%20630px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F74044i144ACD6B4F71CF0E%2Fimage-dimensions%2F630x364%3Fv%3Dv2%22%20width%3D%22630%22%20height%3D%22364%22%20role%3D%22button%22%20title%3D%22txnelson_0-1742483201466.png%22%20alt%3D%22txnelson_0-1742483201466.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%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20%0A%2F%2F%20Open%20Data%20Table%3A%20semiconductor%20capability.jmp%0A%2F%2F%20%E2%86%92%20Data%20Table(%20%22semiconductor%20capability%22%20)%0AOpen(%20%22%24SAMPLE_DATA%2Fsemiconductor%20capability.jmp%22%20)%3B%0A%0AcolNames%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20continuous%2C%20string%20)%3B%0A%0AFor%20Each(%20%7Bcol%7D%2C%20colNames%2C%0A%09If(%20Ends%20With(%20col%2C%20%221%22%20)%20%26amp%3B%20Contains(%20colNames%2C%20Substr(%20col%2C%201%2C%20Length(%20col%20)%20-%201%20)%20%7C%7C%20%222%22%20)%2C%0A%09%09Graph%20Builder(%0A%09%09%09Size(%20534%2C%20456%20)%2C%0A%09%09%09Show%20Control%20Panel(%200%20)%2C%0A%09%09%09Variables(%20X(%20As%20Column(%20col%20)%20)%2C%20Y(%20As%20Column(%20Substr(%20col%2C%201%2C%20Length(%20col%20)%20-%201%20)%20%7C%7C%20%222%22%20)%20)%20)%2C%0A%09%09%09Elements(%20Points(%20X%2C%20Y%2C%20Legend(%203%20)%20)%2C%20Smoother(%20X%2C%20Y%2C%20Legend(%204%20)%20)%20)%0A%09%09)%3B%0A%09%0A%09)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848876%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848876%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJarmo%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3ESieht%20viel%20ordentlicher%20aus%20als%20das%2C%20was%20ich%20hatte%2C%20aber%20ich%20bekomme%20diesen%20Fehler.%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3E%E2%80%9EObjekt%20%E2%80%9ADatentabelle%E2%80%98%20erkennt%20die%20Meldung%20%E2%80%9AHat%20Spalte%E2%80%98%20nicht%E2%80%9C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848882%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848882%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EDas%20wurde%20in%20JMP18%20hinzugef%C3%BCgt%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1742500969200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1742500969200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1742500969200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1742500969200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1742500969200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1742500969200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1742500969200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1742500969200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F74054iC96968C8F5F7F17B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1742500969200.png%22%20alt%3D%22jthi_0-1742500969200.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%2FP%3E%0A%3CP%3ESie%20k%C3%B6nnen%20es%20in%20Contains()%20%C3%A4ndern%20und%20es%20sollte%20meistens%20in%20Ordnung%20sein%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EContains(collist%2C%20lcolname)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848889%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848889%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJarmo%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3EDas%20ist%20naheliegend%2C%20aber%20mir%20f%C3%A4llt%20auf%2C%20dass%20hcolname%20leer%20ist%2C%20w%C3%A4hrend%20lcolname%20einen%20Wert%20hat.%20Muss%20ich%20hcolname%20als%20Objekt%20oder%20Liste%20festlegen%3F%3C%2FP%3E%0A%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848890%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848890%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3Ehcols%20sollte%20eine%20Liste%20aller%20Spalten%20enthalten%2C%20die%20mit%20%22H%22%20enden.%20Diese%20wird%20dann%20in%20For%20Each%20verwendet%2C%20und%20jedes%20Element%20wird%20einzeln%20als%20hcolname%20verwendet.%20Sie%20k%C3%B6nnen%20Debug-Ausdrucke%20hinzuf%C3%BCgen%2C%20um%20zu%20verstehen%2C%20was%20passiert.%20Dies%20ist%20definitiv%20nicht%20die%20einzige%20M%C3%B6glichkeit%2C%20dies%20zu%20tun.%20Sie%20k%C3%B6nnen%20dies%20beispielsweise%20problemlos%20in%20einer%20einzigen%20Schleife%20tun.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848892%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848892%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CBR%20%2F%3E%0A%3CP%3EJarmo%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3EDamit%20komme%20ich%20dem%20Ziel%20etwas%20n%C3%A4her%2C%20aber%20der%20lcolname%20wird%20erst%20mit%20dem%20endg%C3%BCltigen%20Wert%20gef%C3%BCllt.%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EFor%20Each(%7Bhcolname%2C%20index%7D%2C%20hcols%2C%0A%09%7Blcolname%2C%20index%7D%2C%20hcols%20%3D%20Left(hcolname%2C%20Length(hcolname)%20-%201)%20%7C%7C%20%22L%22%3B%0A%09If(dt%20%26lt%3B%26lt%3B%20Contains(collist%2C%20lcolname)%2C%0A%09%09aa%5Bhcolname%5D%20%3D%20lcolname%0A%09)%3B%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848895%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848895%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EBei%20mir%20scheint%20es%20gut%20zu%20funktionieren.%20Sie%20k%C3%B6nnen%20die%20Beispieltabelle%20auf%20Halbleiterf%C3%A4higkeit%20%C3%A4ndern%20und%20am%20Ende%20einige%20Zahlen%20%C3%BCberpr%C3%BCfen.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20default%20to%20here(1)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FSemiconductor%20Capability.jmp%22)%3B%0A%0Acollist%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(string)%3B%0A%0Ahcols%20%3D%20Filter%20Each(%7Bcolname%7D%2C%20colList%2C%0A%09Ends%20With(colname%2C%20%221%22)%3B%0A)%3B%0A%0Aaa%20%3D%20Associative%20Array()%3B%0A%0AFor%20Each(%7Bhcolname%7D%2C%20hcols%2C%0A%09lcolname%20%3D%20Left(hcolname%2C%20Length(hcolname)%20-%201)%20%7C%7C%20%222%22%3B%0A%09If(dt%20%26lt%3B%26lt%3B%20Has%20Column(lcolname)%2C%0A%09%09aa%5Bhcolname%5D%20%3D%20lcolname%0A%09)%3B%0A)%3B%0A%0AShow(aa)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Eaa%20%3D%20%5B%22ESM1%22%20%3D%26gt%3B%20%22ESM2%22%2C%20%22FST1%22%20%3D%26gt%3B%20%22FST2%22%2C%20%22INM1%22%20%3D%26gt%3B%20%22INM2%22%2C%20%22IVP1%22%20%3D%26gt%3B%20%22IVP2%22%2C%20%22NPN1%22%20%3D%26gt%3B%20%22NPN2%22%2C%20%22PBA1%22%20%3D%26gt%3B%20%22PBA2%22%2C%20%22PLG1%22%20%3D%26gt%3B%20%22PLG2%22%2C%20%22PLY1%22%20%3D%26gt%3B%20%22PLY2%22%2C%20%22PNP1%22%20%3D%26gt%3B%20%22PNP2%22%2C%20%22RES1%22%20%3D%26gt%3B%20%22RES2%22%2C%20%22RSP1%22%20%3D%26gt%3B%20%22RSP2%22%2C%20%22SIT1%22%20%3D%26gt%3B%20%22SIT2%22%2C%20%22VDP1%22%20%3D%26gt%3B%20%22VDP2%22%2C%20%22VPM1%22%20%3D%26gt%3B%20%22VPM2%22%5D%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CBR%20%2F%3E%0A%3CP%3ESie%20k%C3%B6nnen%20aber%20auch%20einen%20etwas%20anderen%20Weg%20mit%20etwas%20mehr%20Konfigurationsoptionen%20gehen.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Aendchar1%20%3D%20%221%22%3B%0Aendchar2%20%3D%20%222%22%3B%0A%0Argx_endchar1%20%3D%20Eval%20Insert(%22(.%2B%3F)%5Eendchar1%5E%24%22)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FSemiconductor%20Capability.jmp%22)%3B%0A%0A%0Acollist%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(string)%3B%0A%0Aaa%20%3D%20Associative%20Array()%3B%0AFor%20Each(%7Bcolname%7D%2C%20collist%2C%0A%09col_ptrn%20%3D%20Regex(colname%2C%20rgx_endchar1%2C%20%22%5C1%22)%3B%0A%09If(!IsMissing(col_ptrn)%2C%20%2F%2F%20ends%20with%20H%0A%09%09If(Contains(collist%2C%20col_ptrn%20%7C%7C%20endchar2)%2C%0A%09%09%09aa%5Bcol_ptrn%20%7C%7C%20endchar1%5D%20%3D%20col_ptrn%20%7C%7C%20endchar2%3B%0A%09%09)%3B%0A%09)%3B%0A)%3B%0A%0Ashow(aa)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EBeide%20liefern%20bei%20mir%20die%20gleichen%20Ergebnisse%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848897%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848897%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJim%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3ETolles%20Skript%20und%20viel%20einfacher.%20Ich%20habe%20es%20ein%20wenig%20optimiert%2C%20um%20alle%20Plots%20in%20einem%20%E2%80%9EZusammenstellungs%E2%80%9C%20%3CSPAN%3E-Fenster%20anzuzeigen.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Current%20Data%20Table()%3B%0AcolNames%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20continuous%2C%20string%20)%3B%0ANew%20Window(%20%22Compilation%22%2C%0A%09For%20Each(%20%7Bcol%7D%2C%20colNames%2C%0A%09%09If(%0A%09%09%09Starts%20With(%20col%2C%20%22VT%22%20)%20%26amp%3B%20Contains(%0A%09%09%09%09colNames%2C%0A%09%09%09%09Substr(%20col%2C%201%2C%20Length(%20col%20)%20-%201%20)%20%7C%7C%20%22H%22%0A%09%09%09)%2C%0A%09%09%09Graph%20Builder(%0A%09%09%09%09Size(%20534%2C%20456%20)%2C%0A%09%09%09%09Show%20Control%20Panel(%200%20)%2C%0A%09%09%09%09Variables(%0A%09%09%09%09%09X(%20As%20Column(%20col%20)%20)%2C%0A%09%09%09%09%09Y(%20As%20Column(%20Substr(%20col%2C%201%2C%20Length(%20col%20)%20-%201%20)%20%7C%7C%20%22L%22%20)%20)%0A%09%09%09%09)%2C%0A%09%09%09%09Wrap(%20%3ALOT%20)%2C%0A%09%09%09%09Elements(%0A%09%09%09%09%09Points(%20X%2C%20Y%2C%20Legend(%201%20)%20)%2C%0A%09%09%09%09%09Line%20Of%20Fit(%20X%2C%20Y%2C%20Legend(%203%20)%20)%0A%09%09%09%09)%0A%09%09%09)%0A%09%09)%0A%09)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848899%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Spalten%20nach%20Namen%20zuordnen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848899%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJarmo%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CP%3EMerkw%C3%BCrdigkeiten%20mit%20JMP.%20Das%20erste%20funktioniert%20nicht%2C%20das%20zweite%20schon%2C%20vielleicht%20JMP%2017%3F%20Danke%20f%C3%BCrs%20Aushalten.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
SpannerHead
Level VI

Associate Columns By Name

I got something to work here

 

Solved: Automatically plot associated columns - JMP User Community

 

but I'm pretty sure it's unnecessarily cumbersome.  I have column names ending with the letter H (High) that I need to associate with column names that otherwise match but end with the letter L (Low).  I can create an associative array with the column names having the final character removed.  Snookered as to what to do next?

 

names default to here(1);
dt = Current Data Table();

colList = dt << get column names( string );

for each({col,index}, colList,
	//colList[index] = substr(col,1,3)
	colList[index] = Left(col,Length(col)-1)
);

grps = associative array(colList)<<get keys;

For instance, VT123ABCH needs to plot against VT123ABCL and so forth.


Slán



SpannerHead
10 REPLIES 10
SpannerHead
Level VI

Re: Associate Columns By Name

Jim

 

Great script and a lot simpler.  I tweaked it a bit to have all the plots in a "Compilation" window .

 

Names Default To Here( 1 );
dt = Current Data Table();
colNames = dt << get column names( continuous, string );
New Window( "Compilation",
	For Each( {col}, colNames,
		If(
			Starts With( col, "VT" ) & Contains(
				colNames,
				Substr( col, 1, Length( col ) - 1 ) || "H"
			),
			Graph Builder(
				Size( 534, 456 ),
				Show Control Panel( 0 ),
				Variables(
					X( As Column( col ) ),
					Y( As Column( Substr( col, 1, Length( col ) - 1 ) || "L" ) )
				),
				Wrap( :LOT ),
				Elements(
					Points( X, Y, Legend( 1 ) ),
					Line Of Fit( X, Y, Legend( 3 ) )
				)
			)
		)
	)
);

Slán



SpannerHead

Recommended Articles