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-8059%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E8%A6%8B%E3%81%A4%E3%81%91%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8059%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%3E%E6%95%B0%E5%80%A4%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%88%97%E3%81%8C%E3%81%84%E3%81%8F%E3%81%A4%E3%81%8B%E3%81%82%E3%82%8A%20(%E4%BB%A5%E4%B8%8B%E3%81%AE%E4%BE%8B%E3%82%92%E5%8F%82%E7%85%A7)%E3%80%81%E5%88%97%E5%85%A8%E4%BD%93%E3%81%AE%E5%90%84%E8%A1%8C%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E8%A6%8B%E3%81%A4%E3%81%91%E3%82%8B%E3%81%9F%E3%82%81%E3%81%AE%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E8%80%83%E3%81%88%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E5%8A%A9%E3%81%91%E3%81%A6%E3%81%84%E3%81%9F%E3%81%A0%E3%81%91%E3%82%8C%E3%81%B0%E5%B9%B8%E3%81%84%E3%81%A7%E3%81%99%E3%80%82%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%EF%BC%81%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%E5%80%A4%201%20%E5%80%A4%202%20%E5%80%A4%203%20%E6%9C%80%E5%A4%A7%E5%80%A4%20(%E3%81%93%E3%81%AE%E5%88%97%E3%81%AB%E5%BC%8F%E3%82%92%E5%85%A5%E5%8A%9B%E3%81%97%E3%81%BE%E3%81%99)%3C%2FP%3E%3CP%3E1%209%206%209%3C%2FP%3E%3CP%3E2%201%205%205%3C%2FP%3E%3CP%3E3%207%204%207%3C%2FP%3E%3CP%3E4%202%206%206%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-690692%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690692%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E7%90%86%E7%94%B1%E3%81%AF%E3%82%8F%E3%81%8B%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%81%8C%E3%80%81txnelsons%20%E3%81%AE%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AF%E7%A7%81%E3%81%AB%E3%81%A8%E3%81%A3%E3%81%A6%E3%81%AF%E6%A9%9F%E8%83%BD%E3%81%97%E3%81%BE%E3%81%9B%E3%82%93%E3%81%A7%E3%81%97%E3%81%9F%E3%80%82%3C%2FP%3E%3CP%3E%E3%83%87%E3%83%90%E3%83%83%E3%82%B0%E5%BE%8C%E3%80%81%E6%9C%80%E5%BE%8C%E3%81%AE%E8%A1%8C%E3%82%92%E6%AC%A1%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E5%A4%89%E6%9B%B4%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enamelist%5B%20Loc(%20as%20list(maxes%60)%2C%20Max(%20maxes%20)%20)%5B1%5D%20%5D%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E4%BB%8A%E3%81%AF%E3%81%86%E3%81%BE%E3%81%8F%E3%81%84%E3%81%A3%E3%81%A6%E3%81%84%E3%82%8B%E3%82%88%E3%81%86%E3%81%A7%E3%81%99%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482357%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482357%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%93%E3%82%8C%E3%81%AF%E3%80%81%E6%9C%80%E5%A4%A7%E5%88%97%E3%81%AE%E5%88%97%E5%90%8D%E3%82%92%E8%A1%A8%E7%A4%BA%E3%81%99%E3%82%8B%E7%B0%A1%E5%8D%98%E3%81%AA%E4%BE%8B%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0A%2F%2F%20Open%20Data%20Table%3A%20semiconductor%20capability.jmp%0A%2F%2F%20%E2%86%92%20Data%20Table(%20%22semiconductor%20capability%22%20)%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2Fsemiconductor%20capability.jmp%22%20)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%20%22Example%22%2C%0A%20character%2C%0A%20formula(%0A%20%20If(%20Row()%20%3D%3D%201%2C%0A%20%20%20namelist%20%3D%20%7B%22NPN1%22%2C%20%22NPN2%22%2C%20%22NPN3%22%2C%20%22NPN4%22%7D%0A%20%20)%3B%0A%20%20maxes%20%3D%20%5B%5D%3B%0A%20%20For(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20namelist%20)%2C%20i%2B%2B%2C%0A%20%20%20maxes%20%3D%20maxes%20%7C%7C%20Matrix(%20Column(%20namelist%5Bi%5D%20)%5BRow()%5D%20)%0A%20%20)%3B%0A%20%20If(%20Row()%20%26lt%3B%3D%205%2C%0A%20%20%20Show(%20maxes%20)%0A%20%20)%3B%0A%20%20namelist%5BLoc(%20maxes%2C%20Max(%20maxes%20)%20)%5B1%5D%5D%3B%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482302%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482302%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%93%E3%82%8C%E3%81%AF%E5%9D%87%E7%AD%89%E3%81%A7%E3%81%AF%E3%81%AA%E3%81%84%E5%8F%AF%E8%83%BD%E6%80%A7%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%81%8C%E3%80%81%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%8C%81%E3%81%A4%E5%88%97%E3%81%AE%20%26lt%3B%E5%80%A4%26gt%3B%20%E3%81%A7%E3%81%AF%E3%81%AA%E3%81%8F%E3%80%81%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%8C%81%E3%81%A4%E5%88%97%E3%81%AE%20%26lt%3B%E5%88%97%E5%90%8D%26gt%3B%20%E3%81%8C%E5%BE%97%E3%82%89%E3%82%8C%E3%82%8B%E5%88%97%E5%BC%8F%E3%81%AF%E4%BD%95%E3%81%A7%E3%81%99%E3%81%8B%3FTIA%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-255155%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-255155%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2687%22%20target%3D%22_blank%22%3E%40txnelson%3C%2FA%3E%E3%81%82%E3%81%AA%E3%81%9F%E3%81%AF%E9%AD%94%E6%B3%95%E4%BD%BF%E3%81%84%E3%81%A7%E3%81%99!%20%E3%81%8A%E6%89%8B%E4%BC%9D%E3%81%84%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254723%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254723%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3E%E4%BE%8B%E3%81%AE%E3%81%9F%E3%82%81%E3%81%AB%E4%BD%9C%E6%88%90%E3%81%97%E3%81%9F%E6%A7%8B%E6%96%87%E3%81%AF%E6%A9%9F%E8%83%BD%E3%81%97%E3%81%BE%E3%81%9B%E3%82%93%E3%81%8C%E3%80%81%E3%81%9D%E3%81%93%E3%81%8B%E3%82%89%E5%8F%8E%E9%9B%86%E3%81%97%E3%81%9F%E3%81%93%E3%81%A8%E3%81%AF%E3%80%81%E5%88%97%E3%81%AE%E3%83%AA%E3%82%B9%E3%83%88%E5%85%A8%E4%BD%93%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E5%90%AB%E3%82%80%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E3%81%84%E3%81%86%E3%81%93%E3%81%A8%E3%81%A7%E3%81%99%E3%80%82%E6%95%B0%E5%BC%8F%E3%81%A7%E6%8C%87%E5%AE%9A%E3%81%95%E3%82%8C%E3%81%9F%E3%82%B3%E3%83%BC%E3%83%89%20(%E4%BE%8B%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3Aa%20*%202%20%2B%20%3CLI-EMOJI%20id%3D%22lia_face-with-tongue%22%20title%3D%22%3Acara_con_la_lengua_fuera%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3E%E5%BC%8F%E3%81%AB%E5%BF%85%E8%A6%81%E3%81%AA%E5%AE%9F%E9%9A%9B%E3%81%AE%E3%83%AA%E3%83%86%E3%83%A9%E3%83%AB%E6%96%87%E5%AD%97%E5%88%97%E3%81%A8%E3%81%97%E3%81%A6%E5%85%A5%E5%8A%9B%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82JMP%20%E3%81%AF%E3%80%81%E4%BD%9C%E6%88%90%E3%81%95%E3%82%8C%E3%82%8B%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%81%AB%E6%B8%A1%E3%81%95%E3%82%8C%E3%82%8B%E5%89%8D%E3%81%AB%E3%80%81%E5%BC%8F%E5%86%85%E3%81%AE%20JSL%20%E3%81%AE%E8%A9%95%E4%BE%A1%E3%82%92%E8%A1%8C%E3%81%84%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%E3%81%97%E3%81%9F%E3%81%8C%E3%81%A3%E3%81%A6%E3%80%81%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%9F%E3%81%84%E5%85%AC%E5%BC%8F%E3%81%AF%E5%AE%8C%E5%85%A8%E3%81%AB%E5%AE%9F%E7%8F%BE%E3%81%95%E3%82%8C%E3%81%AA%E3%81%91%E3%82%8C%E3%81%B0%E3%81%AA%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%E3%81%BE%E3%81%9F%E3%80%81%E3%82%B3%E3%83%BC%E3%83%89%E3%81%A7%E3%81%AF%E5%8B%95%E7%9A%84%E3%81%A7%E3%81%82%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%80%81%E3%81%9D%E3%81%AE%E3%81%9F%E3%82%81%E3%81%AB%E3%81%AF%E5%BC%8F%E3%82%B9%E3%83%86%E3%83%BC%E3%83%88%E3%83%A1%E3%83%B3%E3%83%88%E3%82%92%20JSL%20%E3%81%A7%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E5%BC%8F%E3%81%AB%E6%B8%A1%E3%81%99%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%26nbsp%3B%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3E%E4%BB%A5%E4%B8%8B%E3%81%AF%E3%80%81%E3%81%9D%E3%81%AE%E6%96%B9%E6%B3%95%E3%81%AE%201%20%E3%81%A4%E3%82%92%E7%A4%BA%E3%81%99%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%A7%E3%81%99%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0A%0Adt%20%3D%20Current%20Data%20Table()%3B%0A%0A%0A%2F%2F%20The%20formula%20that%20needs%20to%20be%20passed%20into%20the%20new%20column%20JSL%20needs%0A%2F%2F%20to%20look%20like%0A%2F%2F%20%20%20%20%20Max(%20%3ANameA%2C%20%3AUniqueX%2C%20%3AName%20bb%20)%0A%2F%2F%20A%20literal%20string%20of%20%22%3ANameA%2C%20%3AUniqueX%2C%20%3AName%20bb%22%20needs%20to%20be%20created%0A%2F%2F%20and%20then%20plugged%20into%20the%20JSL%20and%20then%20executed%0A%2F%2F%20%20%22%3ANameA%2C%20%3AUniqueX%2C%20%3AName%20bb%22%20is%20just%20an%20illustration%2C%20what%20the%20%0A%2F%2F%20make%20up%20of%20the%20string%20needs%20to%20be%20derived%20from%20the%20actual%20column%0A%2F%2F%20names%20in%20the%20data%20table%0AFreqList%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20string%2C%20numeric%20)%3B%0AfreqString%20%3D%20%22%22%3B%0A%0A%2F%2F%20build%20the%20JSL%20in%20the%20form%20that%20is%20required%20for%20the%20formula%0AFor(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20FreqList%20)%2C%20i%2B%2B%2C%0A%20If(%0A%20%20Contains(%20FreqList%5Bi%5D%2C%20%22Unique%22%20)%20%3D%3D%201%20%7C%0A%20%20Contains(%20FreqList%5Bi%5D%2C%20%22Name%22%20)%20%3D%3D%201%2C%20%0A%20%20If(%20i%3D%3D1%2C%20delim%20%3D%20%22%22%2C%20delim%20%3D%20%22%2C%22)%3B%0A%20%20freqString%20%3D%20freqString%20%7C%7C%20delim%20%7C%7C%20%22%20%3A%22%20%7C%7C%20FreqList%5Bi%5D%0A%20)%0A)%3B%0A%0A%2F%2F%20Run%20the%20command%2C%20passing%20into%20the%20formula%20the%20command%20string%20developed%20above%0AEval(%20Parse(%20%22dt%20%26lt%3B%26lt%3B%20New%20Column%20(%5C!%22Freq%5C!%22%2C%20numeric%2C%20Formula(%20Max(%20%22%20%7C%7C%20freqString%20%7C%7C%20%22%20)))%3B%22%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254713%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254713%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2687%22%20target%3D%22_blank%22%3E%40txnelson%3C%2FA%3E%E7%A7%81%E3%82%82%E5%90%8C%E6%A7%98%E3%81%AE%E5%95%8F%E9%A1%8C%E3%82%92%E6%8A%B1%E3%81%88%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%20%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E5%8F%96%E5%BE%97%E3%81%97%E3%81%9F%E3%81%84%E5%A0%B4%E5%90%88%E3%80%82%20%E3%81%93%E3%81%AE%E4%BE%8B%E3%81%A7%E3%81%AF%E3%80%81FreqList%20%E3%81%A8%E3%81%84%E3%81%86%E5%88%97%E3%81%AE%E3%83%AA%E3%82%B9%E3%83%88%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%20%E6%AC%A1%E3%81%AE%E3%82%88%E3%81%86%E3%81%AA%E5%BC%8F%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E4%BD%9C%E6%88%90%E3%81%97%E3%81%9F%E3%82%82%E3%81%AE%E3%81%AF%E3%80%81%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20current%20data%20table()%3B%0A%0A%0AFreqList%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20string%2C%20numeric%20)%3B%0A%0AFor(%20i%20%3D%20N%20Items(%20FreqList%20)%2C%20i%20%26gt%3B%3D%201%2C%20i--%2C%0AIf(%20Contains(%20FreqList%5Bi%5D%2C%20%22Unique%22%20)%3D%3D%200%2C%0AFreqList%3D%20Remove(%20FreqList%2C%20i%2C%201%20)%2C%0AContains(%20FreqList%5Bi%5D%2C%20%22Name%22%20)%3D%3D%200%2C%0AFreqList%20%3D%20Remove(%20FreqList%2C%20i%2C%201%20)%0A)%0A)%3B%0A%0A%2F%2F%20Then%26nbsp%3B%20I%20was%20thinking%20something%20like%20the%20following%20should%20work%2C%0A%0Adt%20%26lt%3B%26lt%3B%20New%20Column%20(%22Freq%22%2C%20numeric%2C%20Formula(Col%20Max(FreqList)))%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E7%A7%81%E3%81%8C%E6%89%8B%E5%8B%95%E3%81%A7%E8%A1%8C%E3%81%86%E6%96%B9%E6%B3%95%E3%81%AF%E3%80%81%E3%80%8CFreq%E3%80%8D%E3%81%A8%E3%81%84%E3%81%86%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%99%E3%82%8B%E3%81%93%E3%81%A8%E3%81%A7%E3%81%99%E3%80%82%20%E6%AC%A1%E3%81%AB%E3%80%81%20Maximum(%3AFreq1%2C%3AFreq2%2C%3AFreq3%2CFreqN)%20%E3%81%AE%E3%82%88%E3%81%86%E3%81%AA%E6%95%B0%E5%BC%8F%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%E3%81%93%E3%82%8C%E3%81%AB%E3%82%88%E3%82%8A%E3%80%81%E8%A1%8C%E3%81%AB%E5%9F%BA%E3%81%A5%E3%81%84%E3%81%A6%E6%9C%80%E5%A4%A7%E9%A0%BB%E5%BA%A6%E3%82%92%E6%8C%81%E3%81%A4%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%81%8C%E4%BD%9C%E6%88%90%E3%81%95%E3%82%8C%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%81%93%E3%82%8C%E3%82%92%20JSL%20%E3%81%A7%E8%A1%8C%E3%81%86%E3%81%AB%E3%81%AF%E3%81%A9%E3%81%86%E3%81%99%E3%82%8C%E3%81%B0%E3%82%88%E3%81%84%E3%81%A7%E3%81%97%E3%82%87%E3%81%86%E3%81%8B%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189852%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189852%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%8B%E3%82%89%E3%81%AE%E8%B3%AA%E5%95%8F%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4270%22%20target%3D%22_blank%22%3E%40%E3%82%A2%E3%83%80%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%AB%E3%82%B9%E3%83%9F%E3%82%B9%3C%2FA%3E%E3%81%9D%E3%81%97%E3%81%A6%E7%AD%94%E3%81%88%E3%81%9F%E3%81%AE%E3%81%AF%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4550%22%20target%3D%22_blank%22%3E%40pmroz%3C%2FA%3E%E7%B5%90%E6%9E%9C%E3%81%AE%E5%88%97%E3%82%92%E5%AE%9A%E7%BE%A9%E3%81%99%E3%82%8B%E5%BC%8F%E3%81%A7%20Maximum()%20%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%E6%95%B0%E5%BC%8F%E3%81%AF%E5%90%84%E8%A1%8C%E3%81%AB%E3%82%8F%E3%81%9F%E3%81%A3%E3%81%A6%E8%87%AA%E5%8B%95%E7%9A%84%E3%81%AB%E3%83%AB%E3%83%BC%E3%83%97%E3%81%97%E3%80%81%E6%95%B0%E5%BC%8F%E3%81%8C%E9%81%A9%E7%94%A8%E3%81%95%E3%82%8C%E3%81%BE%E3%81%99%E3%80%82%E3%81%97%E3%81%9F%E3%81%8C%E3%81%A3%E3%81%A6%E3%80%81%E8%A1%8C%E5%8F%82%E7%85%A7%E3%82%92%E8%A1%8C%E3%81%86%E5%BF%85%E8%A6%81%E3%81%AF%E3%81%82%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%3C%2FP%3E%0A%3CP%3E%E3%81%9F%E3%81%A0%E3%81%97%E3%80%81%E3%81%93%E3%82%8C%E3%82%92%E3%82%AA%E3%83%BC%E3%83%97%E3%83%B3%20JSL%20%E3%81%A7%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E5%A0%B4%E5%90%88%E3%81%AF%E3%80%81%E5%88%97%E5%8F%82%E7%85%A7%E3%81%AB%E6%B7%BB%E3%81%88%E5%AD%97%E3%82%92%E8%BF%BD%E5%8A%A0%E3%81%97%E3%81%A6%E3%80%81%E3%81%A9%E3%81%AE%E8%A1%8C%E3%82%92%E5%87%A6%E7%90%86%E3%81%99%E3%82%8B%E3%81%8B%E3%82%92%E7%A4%BA%E3%81%99%E3%81%93%E3%81%A8%E3%81%8C%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EFor(%20theRow%20%3D%201%2C%20theRow%20%26lt%3B%3D%2010%2C%20theRow%2B%2B%2C%0A%20%20%20%20%20%3AMaxValue%5BtheRow%5D%20%3D%20Maximum(%20%3AValue%201%5BtheRow%5D%2C%20%3AValue%202%5BtheRow%5D%2C%20%3AValue%202%5BtheRow%5D%20)%3B%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E3%80%8E%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%20%E3%82%AC%E3%82%A4%E3%83%89%E3%80%8F%E3%81%AE%20JSL%20%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E3%83%89%E3%82%AD%E3%83%A5%E3%83%A1%E3%83%B3%E3%83%88%E3%82%92%E5%8F%82%E7%85%A7%E3%81%97%E3%81%A6%E3%81%8F%E3%81%A0%E3%81%95%E3%81%84%E3%80%82%3C%2FP%3E%0A%3CP%3E%E3%83%98%E3%83%AB%E3%83%97%3D%3D%26gt%3B%E6%9B%B8%E7%B1%8D%3D%3D%26gt%3B%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%AC%E3%82%A4%E3%83%89%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189807%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189807%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%A4%9C%E7%B4%A2%E3%81%97%E3%81%9F%E3%81%84%E8%A1%8C%E3%81%8C%E5%A4%9A%E6%95%B0%E3%81%82%E3%82%8B%E5%A0%B4%E5%90%88%E3%80%81%E9%96%A2%E6%95%B0%E3%81%AB%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E8%A1%8C%E3%82%92%E5%85%A5%E5%8A%9B%E3%81%99%E3%82%8B%E3%81%AE%E3%81%A7%E3%81%AF%E3%81%AA%E3%81%8F%E3%80%81%E8%A1%8C%E3%81%AE%E7%AF%84%E5%9B%B2%E3%82%92%E9%81%B8%E6%8A%9E%E3%81%99%E3%82%8B%E9%96%A2%E6%95%B0%E3%81%AF%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%81%8B%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8061%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8061%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%3CA%20__default_attr%3D%22466770%22%20__jive_macro_name%3D%22user%22%20class%3D%22jive_macro%20jive_macro_user%22%20data-objecttype%3D%223%22%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2F%22%20target%3D%22_blank%22%3E%3C%2FA%3E%EF%BC%81%20%E3%82%B7%E3%83%B3%E3%83%97%E3%83%AB%E3%81%AA%E3%82%82%E3%81%AE%E3%81%A7%E3%81%AA%E3%81%91%E3%82%8C%E3%81%B0%E3%81%AA%E3%82%89%E3%81%AA%E3%81%84%E3%81%A8%E6%80%9D%E3%81%A3%E3%81%A6%E3%81%84%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%20%3CSPAN%20__jive_emoticon_name%3D%22happy%22%20__jive_macro_name%3D%22emoticon%22%20class%3D%22jive_macro%20jive_macro_emoticon%20jive_emote%22%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2F5.0.2%2Fimages%2Femoticons%2Fhappy.gif%22%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8060%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%95%B0%E5%BC%8F%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%A6%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%AE%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8060%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%AE%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2F14-2%2Fstatistical-functions-2.shtml%232754448%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMaximum()%20%E9%96%A2%E6%95%B0%3C%2FA%3E%E3%81%82%E3%81%AA%E3%81%9F%E3%81%AE%E4%BB%A3%E3%82%8F%E3%82%8A%E3%81%AB%E3%81%93%E3%82%8C%E3%82%92%E8%A1%8C%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EMaximum(%3AValue%201%2C%20%3AValue%202%2C%20%3AValue%203)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

How to create a formula column to find the maximum of several columns

I have several columns of numeric data (see example below) and I would like to create a formula column to find the maximum value for each row across the columns.  Any help would be appreciated.  Thank you!

Value 1      Value 2      Value 3      Max Value (I would put the formula in this column)

1                    9               6                    9

2                    1               5                    5

3                    7               4                    7

4                    2               6                    6

10 REPLIES 10
jetpeach
Level III

Re: How to create a formula column to find the maximum of several columns

i'm not sure why, but txnelsons code didn't work for me.

after debugging, i had to change last line to:

namelist[ Loc( as list(maxes`), Max( maxes ) )[1] ];

 

now it seems working

Recommended Articles