cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Dorami
Level I

How to change multiple columns attributes using scripts?

I have a table with col name : Name, Sex, Track 1, Track 1, Track 3, Track 4, Track 5 .... Track 50

All cols are character, nominal. I would like to change Track 1 to Track 50 to number, continuous. How can I do that using script?

1 REPLY 1
jthi
Super User

Re: How to change multiple columns attributes using scripts?

Easiest way is to select all columns and use Standardize Attributes

jthi_2-1692004249275.png

 

jthi_0-1692004217810.png

and then copy the captured script

jthi_1-1692004232319.png

 

Other option would be to use << Get Column Names("String") to get list of column names and then loop over that list while using << Data Type("Numeric") and << Modeling Type("Continuous").

-Jarmo

Recommended Articles