Add data to an existing Excel file in Domo?
Is there a way to add monthly data to an already uploaded xls file in Domo? Rather than having to upload a fresh file each month, I was hoping to be able to easily just upload an initial file at the start of the year and then add new rows of data (sometimes up to 100,000) each month.
This would also save me having to re-link the new file to each metric/ visualisation.
TIA
Best Answer
-
You can find it on the connector settings.
As Excel has the row limit you'd be limited to 1M for each file upload because of Excel but it would append those records to your dataset which wouldn't be limited
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
When using the file upload you should be able to set the Update Method on the settings as Append so when you upload a new file containing the new rows it should put it at the end of your dataset.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi Grant, where might the Update Method settings be located? I could not locate this.
Also- if I were able to append my data, is the maximum number of rows that can be appended still ~one million?
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 466 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有