To change the field type from currency to integer

[SNow35]

Hi All,

I have a field whose field type is currency it already has data in it. Is there any way I can change it from currency to integer without loosing the data.

Thanks & Regards,

Shugufta.

[shloke04]

Hi,

If you change the field Type, Data would be Lost. Only way is to take a backup of the Data for your currency field Type and Export in an Excel format. Once the backup has been taken(Make Sure to export the Record Numbers also for your particular Table as this would be required later for mapping back the data), you need to Clear the Data for you Currency field Type   for all the Records in that table then only you would be able to change the field Type from Currency to Integer.

Once the Type has been changed to integer, you can map your Data back to that field using Transform Map and mapping to that field again.

Hope this helps.mark the answer as correct/helpful based on impact.

Regards,

Shloke

[Chuck Tomasi · Accepted solution]

Another option would to create a new field with a new name (e.g. instead of u_cost of type currency, u_amount of type integer) then use a script to copy information over from one field to another. If there are scripts or any other references to the old field, they would have to be updated to the new. The Code Search in studio could help you find such references.

[ANKITA CHARAYA]

i found it heloful

[shloke04]

Hi,

Did you got a chance to Test the Solution provided for your query.

If your query is Resolved, Please mark the answer as correct so that the thread can be removed from the Unanswered list.

Regards,

Shloke