How to upload 60 data sets at once
Is there a good way to securely upload multiple data sets quickly? I have 60 CSVs for 3 clients (180 in totoal) and I'm working on a Mac so I cannot use workbench.
Comments
-
If the schema is the same for each file you could combine them into one. With a mac I think these instructions would work. I have done it on a windows system, but not a mac. https://www.anitaowens.net/blog/2017/5/7/how-to-combine-multiple-csv-files-using-mac-terminal
If the schema is different then you could just upload one at a time through the File Upload connector. That would then create 180 total datasets that you may not want to have...then you'd have to do some ETL work if they are data that you need to join/append.
If this is going to be a reoccurring deal, it may be wise to see if you can email those files into box or directly into Domo or put on a SFTP server and bring in that way.
I hope that helps
Matt
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 702 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 52 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive