topic How to change multiple columns attributes using scripts? in Discussions

How to change multiple columns attributes using scripts?

Dorami — Mon, 14 Aug 2023 08:35:33 GMT

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?

Re: How to change multiple columns attributes using scripts?

jthi — Mon, 14 Aug 2023 09:12:17 GMT

Easiest way is to select all columns and use Standardize Attributes

and then copy the captured script

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").