cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-8560%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ESo%20erstellen%20Sie%20eine%20neue%20Spalte%2C%20wenn%20keine%20gleichnamige%20Spalte%20vorhanden%20ist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8560%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CP%3EHi%2C%3C%2FP%3E%3CP%3EIch%20muss%20f%C3%BCr%20die%20Berechnung%20einige%20Spalten%20verwenden.%20Die%20Frage%2C%20die%20ich%20habe%2C%20ist%2C%20wie%20man%20eine%20neue%20Spalte%20erstellt%20und%20den%20Wert%20jeder%20Zelle%20auf%200%20setzt.%20Wenn%20die%20Spalte%20mit%20dem%20gleichen%20Namen%20nicht%20vorhanden%20ist%20und%20die%20Spalte%20vorhanden%20ist%2C%20unternehmen%20Sie%20nichts.%20Ich%20habe%20es%20unten%20versucht%2C%20aber%20es%20funktioniert%20nicht%2C%20da%20die%20Spalte%20bereits%20vorhanden%20ist.%20Kann%20mir%20jemand%20helfen%3F%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%3CSPAN%20style%3D%22color%3A%20%23008000%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%230000dd%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20Datentabelle%3C%2FSPAN%3E%3CSTRONG%20style%3D%22%3A%20%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20(%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23800080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%E2%80%9EFinalBiningTable%E2%80%9C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3CSTRONG%3E%20)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%26lt%3B%26lt%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20Spaltennamen%20abrufen%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20()%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3CSTRONG%3E(%3C%2FSTRONG%3E%20Column_list%3CSTRONG%3E%20)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%20style%3D%22%3A%20%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E((%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%230000dd%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20enth%C3%A4lt%3C%2FSPAN%3E%3CSTRONG%20style%3D%22%3A%20%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20(%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20Column_list%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23800080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%E2%80%9EN(P%2C%20F)%E2%80%9C%3C%2FSPAN%3E%3CSTRONG%20style%3D%22%3A%20%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20))%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%3D%3D%3C%2FSPAN%3E%3CSTRONG%20style%3D%22%3A%20%3B%20color%3A%20%23008080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%200%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%230000dd%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20Datentabelle%3C%2FSPAN%3E%3CSTRONG%20style%3D%22%3A%20%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20(%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23800080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%E2%80%9EFinalBiningTable%E2%80%9C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3CSTRONG%3E%20)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%26lt%3B%26lt%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20Neue%20Spalte%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20(%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23800080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%E2%80%9EN(P%2C%20F)%E2%80%9C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20numerisch%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20Ordinal-%3CSTRONG%3E%20)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%3B%3A%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%230000dd%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20Name%3C%2FSPAN%3E%3CSTRONG%20style%3D%22%3A%20%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20(%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23800080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%E2%80%9EN(P%2C%20F)%E2%80%9C%3C%2FSPAN%3E%3CSTRONG%20style%3D%22%3A%20%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20)%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%26lt%3B%26lt%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20Legen%20Sie%20jeden%20Wert%20fest%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23008080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%200%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20)%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%3B%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%230000dd%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20leer%3C%2FSPAN%3E%3CSTRONG%20style%3D%22%3A%20%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20())%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23000080%3B%20font-size%3A%2010pt%3B%20font-family%3A%20Courier%20New%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8563%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20So%20erstellen%20Sie%20eine%20neue%20Spalte%2C%20wenn%20keine%20gleichnamige%20Spalte%20vorhanden%20ist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8563%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EDer%20Standarddatentyp%20zum%20Abrufen%20von%20Spaltennamen%20ist%20eine%20Liste%20von%20Spalten%20(des%20Spaltendatentyps).Wenn%20Sie%20das%20String-Argument%20hinzuf%C3%BCgen%2C%20erhalten%20Sie%20eine%20Liste%20von%20Spaltennamen%20als%20Strings.Sie%20haben%20versucht%2C%20einen%20Spaltendatentyp%20mit%20einer%20Zeichenfolge%20zu%20vergleichen.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8562%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20So%20erstellen%20Sie%20eine%20neue%20Spalte%2C%20wenn%20keine%20gleichnamige%20Spalte%20vorhanden%20ist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8562%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EDanke!%20PMroz%3C%2FP%3E%3CP%3EWas%20stimmt%20in%20meinen%20Codezeilen%20nicht%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8561%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20So%20erstellen%20Sie%20eine%20neue%20Spalte%2C%20wenn%20keine%20gleichnamige%20Spalte%20vorhanden%20ist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8561%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%20style%3D%22margin-bottom%3A%20.0001pt%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20green%3B%22%3E%2F%2Fdt%20%3D%20Datentabelle(%22FinalBiningTable%22)%3B%20%2F%2F%20Kommentieren%20Sie%20Ihre%20Tabelle%20aus%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%20style%3D%22margin-bottom%3A%20.0001pt%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3Edt%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20%230000dd%3B%22%3E%20offen%3C%2FSPAN%3E%3CSTRONG%20style%3D%22color%3A%20black%3B%20font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%22%3E%20(%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20purple%3B%22%3E%20%E2%80%9E%24sample_data%5CBig%20Class.jmp%E2%80%9C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%3CSTRONG%3E%20)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%20style%3D%22margin-bottom%3A%20.0001pt%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3ESpaltenliste%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20dt%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%26lt%3B%26lt%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20Spaltennamen%20abrufen%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20(%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20Zeichenfolge%3CSTRONG%3E%20)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%20style%3D%22margin-bottom%3A%20.0001pt%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20%230000dd%3B%22%3EWenn%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%3CSTRONG%3E%20(%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20!%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20%230000dd%3B%22%3E%20enth%C3%A4lt%3C%2FSPAN%3E%3CSTRONG%20style%3D%22color%3A%20black%3B%20font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%22%3E%20(%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20Column_list%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20purple%3B%22%3E%20%E2%80%9EN(P%2C%20F)%E2%80%9C%3C%2FSPAN%3E%3CSTRONG%20style%3D%22color%3A%20black%3B%20font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%22%3E%20)%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20style%3D%22margin-bottom%3A%20.0001pt%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3Edt%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%26lt%3B%26lt%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20Neue%20Spalte%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20(%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20purple%3B%22%3E%20%E2%80%9EN(P%2C%20F)%E2%80%9C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20numerisch%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20Ordinal-%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%26lt%3B%26lt%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20Legen%20Sie%20jeden%20Wert%20fest%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20teal%3B%22%3E%200%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20black%3B%22%3E%20))%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%20style%3D%22color%3A%20black%3B%20font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%22%3E)%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20'Courier%20New'%3B%20color%3A%20navy%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
robust1972
Level IV

how to creat new column if same name column does not exist

hi,

I need to use few columns to do calculation. the  question I have is how to create new column and set value of each cell to 0 if same name column does not exist, it there is the column, do nothing. I tried below but it does not work the column already exist. can someone helps me out?


=Data Table( "FinalBiningTable" ) << Get Column Names();

(Column_list);

((contains(Column_list, "N(P, F)"))==0, Data Table( "FinalBiningTable" ) << New Column( "N(P, F)",numeric, ordinal );:Name("N(P, F)") << Set Each Value(0);, empty());

1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User

Re: how to creat new column if same name column does not exist

//dt = data table("FinalBiningTable");  // Uncomment for your table

dt = open( "$sample_data\Big Class.jmp" );

column_list = dt << Get Column Names(string);

if (!contains(Column_list, "N(P, F)"),

      dt << New Column( "N(P, F)",numeric, ordinal, << Set Each Value(0));

);

View solution in original post

3 REPLIES 3
pmroz
Super User

Re: how to creat new column if same name column does not exist

//dt = data table("FinalBiningTable");  // Uncomment for your table

dt = open( "$sample_data\Big Class.jmp" );

column_list = dt << Get Column Names(string);

if (!contains(Column_list, "N(P, F)"),

      dt << New Column( "N(P, F)",numeric, ordinal, << Set Each Value(0));

);

robust1972
Level IV

Re: how to creat new column if same name column does not exist

Thanks! PMroz

What is wrong in my lines of code?

pmroz
Super User

Re: how to creat new column if same name column does not exist

The default data type for get column names is a list of columns (of column data type).  When you add the string argument you get a list of column names as strings.  You were trying to compare a column data type to a string.