I want to change the type of an existing field.

[M_Tomy]

Dear Experts

I am new to table implementation.

For a table, I would like to be able to handle ”decimal” numbers for fields that are currently of type "Integer".
What should I do?

Best regards

[Pavankumar_1 · Accepted solution]

Hi @M_Tomy ,

If you want change the field type from integer to decimal make sure there is no data on that field.

If there is no data you can go to the dictionary of field and change the field type to decimal.

if they have any data on your integer field export the data and remove the data on integer to change the type.

Once you changed the type to decimal the import on that decimal field.

Try this on your lower instance or pdi.

[M_Tomy]

Dear Pavankumar.

Thank you very much.
Resolved.

[Pavankumar_1]

Hi @M_Tomy ,

Great to hear that it got resolved.