Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
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.
Hi @prash_,
Would you please provide screenshots so we can get a better idea of what you are trying to do? What formula are you using?
Thanks,
Jordan
Got the solution. Thank you!
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.
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.