not getting exact value

Solved!
prash_
Level 3
not getting exact value

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.

0 Kudos
1 Solution
tgb417

@prash_ 

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. 

https://community.dataiku.com/t5/Using-Dataiku/Dataiku-forces-column-type-removes-leading-zeros/m-p/...

 

 

--Tom

View solution in original post

0 Kudos
4 Replies
JordanB
Dataiker

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

0 Kudos
prash_
Level 3
Author

Got the solution. Thank you!

0 Kudos
tgb417

@prash_ 

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. 

https://community.dataiku.com/t5/Using-Dataiku/Dataiku-forces-column-type-removes-leading-zeros/m-p/...

 

 

--Tom
0 Kudos
tgb417

@prash_ 

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.

https://community.dataiku.com/t5/Product-Ideas/Override-to-Standard-quot-Duck-Typing-quot-of-Variabl...

Looks like I have two varients of this suggestion.

https://community.dataiku.com/t5/Product-Ideas/The-ability-to-turn-off-Cell-level-quot-Duck-Typing-q...

 

--Tom
0 Kudos