Change Auto-Typing to an off or on option with default “Off”

Would like to have the Auto-Typing setup as an option that can be turned off and on with the default being “Off”. This feature is changing my unit serial numbers (230836735F) to a Float (2.30836735E8) which causes me to lose records when joining on the unit serial numbers field in a following step. This will cause my reports to be wrong. If I understand what it is doing, it interprets "D" to Double, "E" to scientific notation, and "F" to Float. I have the workaround (concat("'",strval("MODEL_SERIAL_NBR"),"'")) implemented to fix this but if you don’t know this is happening you will lose records that should be included. At a minimum can we have a pop up that this feature is being used and modifying your data in the recipe so we can fix it. I have to go back through my workflows to see if this is doing other things that I don't want.
Comments
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,574 Neuron
Generally speaking Dataiku will not change the type of your column. Maybe you are importing the data from a type less source like CSV files?
-
The data comes in from an Oracle database as a string and goes in a window recipe as a string. I have worked on this with an Aimpoint employee that is helping us with the migration from Alteryx to Dataiku and they say that this is caused by the Auto Typing feature in Dataiku.
-
Also the output of that column is a string, but the serial number is 2.30836735E8 vs actual serial number 230836735F.