Importing a value with leading zero

user098322
user098322 Member
in Magic ETL

Friends,

 

I am importing a simple dataset, and the leading zeros are being truncated.  Example:

 

I want: 000001

But end result is: 1

 

Does anyone have any suggestions about how to work around this? Thanks.

Best Answer

  • Ashleigh
    Ashleigh Coach
    Answer ✓

    You could always add them back using an ETL, if the leading zeros is always constant you can add that number or you could add a set number, say 10, and then do a right substring to get any non-zero first and then the rest zeros. Like this 

    orginal: 1

    padded: 00000000001

    substring (3 places) : 001

    **If this answer solved your problem be sure to like it and accept it as a solution!

Answers

  • Unknown
    Unknown

    If you are not looking to aggregate this column, then try converting the data type to text (Probably create another column so you don't alter the original one) and and then trying importing.

  • Ashleigh
    Ashleigh Coach
    Answer ✓

    You could always add them back using an ETL, if the leading zeros is always constant you can add that number or you could add a set number, say 10, and then do a right substring to get any non-zero first and then the rest zeros. Like this 

    orginal: 1

    padded: 00000000001

    substring (3 places) : 001

    **If this answer solved your problem be sure to like it and accept it as a solution!

  • MarkSnodgrass
    MarkSnodgrass Coach

    If you are using Domo Workbench to send the data to Domo, you can go to the Schema tab and change the data type to Text or String. This would eliminate the need to do anything in the ETL. 

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories