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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 304 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 773 Beast Mode
- 74 App Studio
- 43 Variables
- 726 Automate
- 185 Apps
- 466 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive