Leading zeros truncated! Datatype changing

jp1

Hello Community,

I'm facing an issue that, I've a column in a dataset for which data type is a string and the meaning type is text and when I shared this to another project data type hasn't changed but it's truncated the leading zeros! thus the meaning is returned as integer. How can I not lose leading zeros without using any recipe as i'm just sharing the dataset in other project!!

Thanks You in Advance! Much appreciated if any of you help me out on this!

Alexandru

Hi @jp1
,
You could append a character to your column and thus transform these to e.g. z0001124 thus it will always be treated as a string even if inferred further upstream in your flow.

Thanks,

tgb417

@jp1

here are some other posts on Dataiku.com that could be helpful.

https://community.dataiku.com/t5/Knowledge-Base/How-to-pad-a-number-with-leading-zeros/tac-p/10807

https://community.dataiku.com/t5/Using-Dataiku/not-getting-exact-value/td-p/34193