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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 467 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive