Appending new data to an existing dataset
Hi all, hoping for some basic help and advice here.
I manage a Domo dashboard, powered by a single dataset which is updated each month.
Each month I am adding approximately 4,000 lines of data over 41 columns. What I am trying to achieve is the ability to add data, clean it via Magic ETL and save to the same original dataset. This is mainly to help me not have to relink the dashboard charts to a new dataset.
The question is, how do I acheive this? Can I have 'output dataset 'x', add new rows through appending data input 'A' and have the resulting output still named as 'output dataset 'x'?
Thanks
Best Answer
-
The output tile in Magic ETL has an append option, which may be the easiest option for you. If not, you can do what you proposed, which is called a recursive dataflow. There's some documentation here:
0
Answers
-
The output tile in Magic ETL has an append option, which may be the easiest option for you. If not, you can do what you proposed, which is called a recursive dataflow. There's some documentation here:
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive