not getting exact value

prash_

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.

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/21826#

JordanB

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

prash_

Got the solution. Thank you!

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-Variables-in-DSS/idi-p/31904

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-quot-within/idi-p/16792