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.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有