- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Script to convert data type
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.