topic Re: Changing datatype of a column in Discussions

Changing datatype of a column

anuashka0 — Wed, 02 Mar 2016 22:33:01 GMT

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?

Re: Changing datatype of a column

ron_horne — Wed, 02 Mar 2016 23:57:25 GMT

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

Re: Changing datatype of a column

txnelson — Thu, 03 Mar 2016 01:04:10 GMT

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.

Re: Changing datatype of a column

anuashka0 — Thu, 03 Mar 2016 15:39:30 GMT

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