Exporting Mega Tables


Do Mega Tables usually tell you if your export is missing data? I have a mega table with 100,000 rows but when I export, it gives me 50,000 but there is no error message saying it did not export all data.
Best Answer
-
@Ashleigh
The limits for exporting from Mega Table to Excel are listed in this KB article:
"When exporting to Excel, only data that is displayed in the Card will be exported, up to 1M cells of data while exporting to CSV will output all rows. For Megatables, Pivot tables, and HTML tables, this is 50k rows by default and up to 100k rows by manually increasing the row limit inside of Analyzer."
Your Analyzer will likely say "All Rows", but if you change it to 100,000 then you will get 100,000 rows in your Excel export.
I hope this helps!2
Answers
-
I believe it is a limitation with the Excel option when choosing Send/Export. I just tested with an mega table card that had 84k rows. When I chose Excel, it only exported 50k rows. When I chose CSV, I got all 84k rows.
**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.2 -
It does seem like this should be something that you are warned about prior to exporting. Did you want to post this in the Ideas Exchange @Ashleigh ?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
@ST_-Superman-_ yea I can post it there, I just wanted to double check it wasn't an error on my end because I've seen an excel report give an error before but I think it may have been for a pivot table export.
0 -
@Ashleigh
The limits for exporting from Mega Table to Excel are listed in this KB article:
"When exporting to Excel, only data that is displayed in the Card will be exported, up to 1M cells of data while exporting to CSV will output all rows. For Megatables, Pivot tables, and HTML tables, this is 50k rows by default and up to 100k rows by manually increasing the row limit inside of Analyzer."
Your Analyzer will likely say "All Rows", but if you change it to 100,000 then you will get 100,000 rows in your Excel export.
I hope this helps!2
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 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
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive