Change of field type.

[yandp]

Hello all, 

While trying something, i had accidentally changed a field type from reference to list type.
now i want to change the field type back to reference, there is error as below.

'. Cannot convert from 'List' to 'Reference'.

Any idea how can i resolve this ? like any other method to change field type?

Thank you very much in advanced.

[Dr Atul G- LNG]

Hi @yandp 

Take back up of that field, and delete all values and then change the type and add the values.

[yandp]

Hi @Dr Atul G- LNG ,
thank you for the help.
I am sorry, i am not sure how to do this. 
backup is referring to the reference data, delete all value is referring to which value?

Sorry for the trouble.

Thank you.

[Dr Atul G- LNG]

Hi @yandp 

You can try this in PDI first.

Take back of all records of that table.

Delete the values from that field which you want to change.

Change the data type

now bring the old values of that field. 

[yandp]

Hello @Dr Atul G- LNG ,
thank you i have try this , but i still cannot save the after change the field type,.

look like no way to do it!

[Dr Atul G- LNG]

What error you are getting? share screenshot