Dataiku forces column type, removes leading zeros

mrs25 Registered Posts: 3 ✭✭✭


I am trying to store an ID column as a text/character column and not an integer column. How would I go about forcing the column type of a Dataiku Dataset? I forced it manually when viewing the dataset sample, but when I built the dataset again, it forced it back, interpreting the column as an integer instead of a character, removing the leading zeros.

I also tried to force the column type in the code (I am using R), but it didn't work. Additionally, the same column was interpreted as a character/text column earlier in the flow, but it's interpreted differently later on in the flow in my output dataset.

Please note that no transformations are done on this particular column throughout the flow.

Thank you.


Setup Info
      Help me…