cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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