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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 730 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive