Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

not getting exact value

Solved!
prash_
Level 2
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 2
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