What is the maximum number of columns allowed in a dataset ?
Hi,
I am trying to upload some survey data via excel into Domo, I am exceeding the allowed limit and need to understand how I can get around this.
Can I split the data and rejoin in ETL or will I face the same problem when I attempt to join ?
Thanks,
Cathy
Answers
-
Yes, you can split your data and rejoin the data in Magic ETL. You might also want to look make use of the select columns tile while you are in the ETL and remove columns that you don't think will be used, or branch columns off into separate datasets. Keep in mind, if you want to use a table card, that card type is limited to 100 columns.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
@cathynewton there is a default limit; however, if you contact support they can help you / lift the limit.
That said, in my experience, you never need more than a hundred columns unless your data is structured poorly. If you data is structured poorly, then it probably makes sense to restructure it before you pull it into Domo.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 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
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive