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.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 103 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 41 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 400 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 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