topic Re: Script to convert data type in Discussions

Script to convert data type

CanhKhong — Fri, 09 Jun 2023 19:55:32 GMT

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

Re: Script to convert data type

CanhKhong — Thu, 26 Aug 2021 15:27:36 GMT

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

Re: Script to convert data type

Jeff_Perkinson — Thu, 26 Aug 2021 15:42:13 GMT

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.