Magic ETL
Magic ETL
How to append monthly data?
Hello,
Please let me ask how to append monthly data to accumulated data.
I want to append monthly data using DataSet via Email Connector on the accumulated data from January to April.
For example, I upload May data by using email connector in May, the output dataset will be for January-May data.
However, after that I upload the June data by email in June, the output data will be the Jan-Apr and June Datasets. Obviously, the data for May will be lost.
How can I append monthly data?
I thought that it could be solved by Appending Update mode in DataSet via Email Connector, but it seemed that DataSet via Email Connector can't set append.
Thank you.
Welcome!
Best Answers
-
Hi @eriena
You'll want to utilize a recursive dataflow. The knowledge base has several different articles on how to do this. Here's the Magic ETL version:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
the dataset via e-mail connector does have an update mode of append, but it can be challenging if you are toggling back and forth and not lose what is currently stored.
I might suggest a recursive dataflow. Here is the KB article on how to create it in Magic ETL.
**Check out my Domo Tips & Tricks Videos
**Make sure to
any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Hi @eriena
You'll want to utilize a recursive dataflow. The knowledge base has several different articles on how to do this. Here's the Magic ETL version:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
the dataset via e-mail connector does have an update mode of append, but it can be challenging if you are toggling back and forth and not lose what is currently stored.
I might suggest a recursive dataflow. Here is the KB article on how to create it in Magic ETL.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
0
-
0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 46 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive