abirakundu23
Giga Sage

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

abirakundu23_0-1720928031662.pngabirakundu23_1-1720928080896.png

abirakundu23_2-1720928102994.png

 

Best practice we can use string data type.

Please mark helpful & correct answer its worthy for you.