Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Leading zeros truncated! Datatype changing

jp1
Level 2
Leading zeros truncated! Datatype changing

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!

0 Kudos
2 Replies
AlexT
Dataiker

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,

0 Kudos