Subscribe Bookmark RSS Feed

Changing datatype of a column

anuashka0

Community Trekker

Joined:

Mar 2, 2016

I am trying to change a numeric column to character using column info window. But it changes back to numeric automatically once I change it to character value. Can someone help me in fixing this issue?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

I believe you will find the column you are trying to change has a formula that is setting it's value.  To be able to change this value, you will need to go to the Column Info for the column, click on the formula column property, and then click on remove.  This will not remove the values from the column, but will just remove the formula.  The values in the column have now become just regular numeric values.  Now you will be able to change the data type to character.

Jim
3 REPLIES
ron_horne

Super User

Joined:

Jun 23, 2011

hi anuashka0​,

this probably happens since the column contains at least one character in one row. you will need to delete it or change it to a numeric value before enforcing the change of the column type.

ron

Solution

I believe you will find the column you are trying to change has a formula that is setting it's value.  To be able to change this value, you will need to go to the Column Info for the column, click on the formula column property, and then click on remove.  This will not remove the values from the column, but will just remove the formula.  The values in the column have now become just regular numeric values.  Now you will be able to change the data type to character.

Jim
anuashka0

Community Trekker

Joined:

Mar 2, 2016

Thank You Jim. That was precisely the problem I was facing. Your suggestion helped me fix the issue!! Thanks