BOX import assigns column schema as number, causing leading zeros to drop, cannot add back
I've connected a number of CSV files via the BOX connector. There are a few columns that may have data with leading zeros. The box connector is automatically assigning the schema for these columns as number, which drops the zeros. The data is not patterned in a way that would allow me to add the zeros back in by padding the text after the import (the string length varies, so it's impossible to know if a zero was dropped).
Is there a way to force the BOX connector to import the CSV file column as a text field rather than a number (even though all the elements in the column are numbers)?
Comments
-
The connector will recognize empty spaces as text so you could try adding trailing or leading spaces.
0 -
Unfortunately - these csv files are overwritten regularly, so editing them each time with a space would be time consuming.
I would really like to approach a solution that doesn't require manual edits to the CSV file.
Is this a limitation of the CSV import tool with BOX?
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 373 Beast Mode
- 20 Variables
- 484 Automate
- 102 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive