Add data to an existing Excel file in Domo?

user034528
user034528 ⚪️
in Dataflows

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

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    You can find it on the connector settings.

    Screen Shot 2022-04-06 at 8.00.49 AM.png


    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!**

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    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!**
  • user034528
    user034528 ⚪️

    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?

Categories