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-848192%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EGroupColumns%20%E5%9C%A8%20v18%20%E4%B8%AD%E5%BC%95%E5%8F%91%E5%BC%82%E5%B8%B8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848192%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E4%BA%B2%E7%88%B1%E7%9A%84%E7%A4%BE%E5%8C%BA%EF%BC%9A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%E8%87%AA%E4%BB%8E%E6%88%91%E8%BD%AC%E5%88%B0%20v18%20%E5%90%8E%EF%BC%8C%E4%BB%A5%E5%89%8D%E8%BF%90%E8%A1%8C%E8%89%AF%E5%A5%BD%E7%9A%84%E5%87%BD%E6%95%B0%E8%B0%83%E7%94%A8%E7%8E%B0%E5%9C%A8%E5%BC%95%E5%8F%91%E4%BA%86%E5%BC%82%E5%B8%B8%EF%BC%88%E4%BB%85%E5%9C%A8%E8%B0%83%E8%AF%95%E6%A8%A1%E5%BC%8F%E4%B8%8B%EF%BC%8C%E5%90%A6%E5%88%99%EF%BC%8C%E5%8F%AA%E6%98%AF%E9%BB%98%E9%BB%98%E8%B7%B3%E8%BF%87%EF%BC%89%EF%BC%9A%3C%2FP%3E%3CUL%3E%3CLI%3E%E8%BF%99%E5%9C%A8%20v17%20%E4%B8%AD%E6%9C%89%E6%95%88%EF%BC%9A%3C%2FLI%3E%3C%2FUL%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EcolList%20%3D%20dt2%20%26lt%3B%26lt%3B%20Get%20Column%20Names(%20String%20)%3B%0Adt2%20%26lt%3B%26lt%3B%20GroupColumns(%20%3CU%3E%3CSTRONG%3EcolList%5B1%5D%3C%2FSTRONG%3E%3C%2FU%3E%20%3A%3A%20%3ATime%20At%20Exit%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CUL%3E%3CLI%3E%E5%9C%A8%20v18%20%E4%B8%AD%E5%BC%95%E5%8F%91%E6%AD%A4%E5%BC%82%E5%B8%B8%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22HubPSDe_0-1742225867279.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22HubPSDe_0-1742225867279.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22HubPSDe_0-1742225867279.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F73950i506B2C59C8D150FA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22HubPSDe_0-1742225867279.png%22%20alt%3D%22HubPSDe_0-1742225867279.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3EFYI%2C%20this%20explicit%20workaround%20works%3A%3CBR%20%2F%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt2%20%26lt%3B%26lt%3B%20GroupColumns(%20%3CU%3E%3CSTRONG%3E%3ATime%20At%20Entrance%20Queue%3C%2FSTRONG%3E%3C%2FU%3E%20%3A%3A%20%3ATime%20At%20Exit%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%E6%9C%89%E4%BA%BA%E8%83%BD%E5%91%8A%E8%AF%89%E6%88%91%E4%B8%BA%E4%BB%80%E4%B9%88%3CEM%3E%3CSTRONG%3E%3CU%3E%E5%88%97%E8%A1%A8%5B1%5D%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FEM%3E%E5%9C%A8%E8%BF%99%E7%A7%8D%E6%83%85%E5%86%B5%E4%B8%8B%E4%B8%8D%E5%86%8D%E8%B5%B7%E4%BD%9C%E7%94%A8%E5%90%97%EF%BC%9F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-848192%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%E8%87%AA%E5%8A%A8%E5%8C%96%E5%92%8C%E8%84%9A%E6%9C%AC%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848210%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9AGroupColumns%20%E5%9C%A8%20v18%20%E4%B8%AD%E5%BC%95%E5%8F%91%E5%BC%82%E5%B8%B8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848210%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E7%8C%9C%20JMP18%20%E4%B8%8D%E5%96%9C%E6%AC%A2%E4%BD%A0%E5%B0%86%E5%AD%97%E7%AC%A6%E4%B8%B2%E4%B8%8E%E5%85%B6%E4%BB%96%E6%A0%BC%E5%BC%8F%E6%B7%B7%E5%90%88%EF%BC%88%E8%AF%A5%E6%A0%BC%E5%BC%8F%E6%80%BB%E4%BD%93%E6%9D%A5%E8%AF%B4%E9%9D%9E%E5%B8%B8%E5%A5%87%E6%80%AA%EF%BC%89%E3%80%82%E6%88%91%E4%B8%AA%E4%BA%BA%E5%8F%AA%E4%BC%9A%E4%BD%BF%E7%94%A8%E5%88%97%E5%88%97%E8%A1%A8%E6%88%96%E5%88%97%E5%90%8D%E7%A7%B0%EF%BC%88%E4%BD%9C%E4%B8%BA%E5%AD%97%E7%AC%A6%E4%B8%B2%EF%BC%89%E5%92%8C%E6%95%B0%E5%AD%97%E3%80%82https%20%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F18.1%2F%23page%2Fjmp%2Fgroup-columns.shtml%23ww805157%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F18.1%2F%23page%2Fjmp%2Fgroup-columns.shtml%23ww805157%3C%2FA%3E%3C%2FP%3E%0A%3CBR%20%2F%3E%0A%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
HubP-SDe
Level I

GroupColumns raising exception in v18

Dear Community,

 

Since I moved to v18, a function call that previously worked fine, now raises an exception (in Debug mode only, otherwise, just skipped silently):

  • This worked in v17:
colList = dt2 << Get Column Names( String );
dt2 << GroupColumns( colList[1] :: :Time At Exit );
  • Raises this exception in v18
    HubPSDe_0-1742225867279.png
  • FYI, this explicit workaround works:
    dt2 << GroupColumns( :Time At Entrance Queue :: :Time At Exit );

Can anyone tell why colList[1] does not work anymore in this context?

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: GroupColumns raising exception in v18

My guess is that JMP18 doesn't like you mixing string with the other format (that format is overall very weird). Personally I would just use list of columns or name of column (as a string) and number. https://www.jmp.com/support/help/en/18.1/#page/jmp/group-columns.shtml#ww805157

 

 

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: GroupColumns raising exception in v18

My guess is that JMP18 doesn't like you mixing string with the other format (that format is overall very weird). Personally I would just use list of columns or name of column (as a string) and number. https://www.jmp.com/support/help/en/18.1/#page/jmp/group-columns.shtml#ww805157

 

 

-Jarmo

Recommended Articles