I want to export my dataset as chunk of excel/csv file
I have a dataset in domo and I want to export the it in to chunks of excel/CSV file and each file having 5 lakhs rows. I found this link on domo developer. Can some one guide me how to proceed with this? I have Python 3.7.1 installed on my system and also having Anaconda distribution to work with Python if needed.
https://developer.domo.com/docs/dataset/import-and-export-data#Export%20Data
PS: I am very new in DOMO and exporting that data manually that took whole day to export chunks of file using DOMO UI.
Thanks in advance.
Kulchandra
Comments
-
Hi @user094816
You can't directly export the data in chunks from the Domo API, only the entire dataset. There are some sample Python files they provide to show how to accomplish this: https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py shows how to connect to Domo and export a dataset. I'd recommend you start with that example file.
Once you have the data exported to a CSV you could then utilize some looping, other package or even another tool to split your file into smaller chunks.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Is it possible to export whole dataset (millions or rows) in single CSV file with this solution?
0 -
Yes, there isn't a limitation on the number of records a CSV can store or that would be exported from the API to my knowledge. You'll just have a very large file.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 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
- 181 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive