not getting exact value
![prash_](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar5.png)
A column in my dataset which consist of the value like 08900
I need to create another column B and to keep the value of A i.e. 08900. I tried using formula in prepare recipe but its giving me value as 8900 instead of 08900. What should be done here to get the exact value.
Best Answer
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
When dataiku created a new column it does what I call “duck typing” the values you are providing look like numbers so Dataiku treats the value as a number and trims the leading number “0”. There are some discussion here in the dataiku community about us postal codes and these duck typing challenges that might be useful to you.
Answers
-
Got the solution. Thank you!
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
Here is a link to a product idea related to this issue. If you think this revised behavior would be helpful to you. I'd like to invite you to upvote the idea.
Looks like I have two varients of this suggestion.