Importing a value with leading zero
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
-
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!
2
Answers
-
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.
0 -
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!
2 -
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 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive