cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
CanhKhong
Level III

Script to convert data type

Good morning,

I have several columns in a table that have data type of numeric. 

Is there a script that I can run it to change the columns instead of manually change the columns one by one?

 

Thanks,

Canh 

1 ACCEPTED SOLUTION

Accepted Solutions
CanhKhong
Level III

Re: Script to convert data type

I would like to clarity on my question that I meant "is there a script that I can run it to change the data type from numeric to character instead of manually change the columns one by one?"

 

Canh

 

View solution in original post

2 REPLIES 2
CanhKhong
Level III

Re: Script to convert data type

I would like to clarity on my question that I meant "is there a script that I can run it to change the data type from numeric to character instead of manually change the columns one by one?"

 

Canh

 

Jeff_Perkinson
Community Manager Community Manager

Re: Script to convert data type

2021-08-26_11-40-43.296.png

 

You could write a script to do that but it's not necessary. Select the columns you want to change and choose Cols->Standardize Attributes. That will let you change data type, modeling type, column properties, etc. for many columns at once.

 

 

-Jeff