Insert string value to a field of type decimal

[JPSS]

Hi,

Can we instert string value to an out of the box field of type decimal.

[abirakundu23]

Hi @JPSS,

We cannot store "string" value to "Decimal field type" which will be troughing the validation error as data type mismatch. If we follow below approach, then will be able to store string as in Decimal field type.
I have tested in my PDI, please find below screenshots

Best practice we can use string data type.

Please mark helpful & correct answer its worthy for you.

[-O-]

Depending on what you mean by "we insert" (do you mean using code, flow, something else?) you could create a Decision Table (which can be referenced/used from/in both code and flow) "converting" texts "Good", "Neutral" and "Bad" to numbers and store the numbers resulting from running the decision instead.