Append to dataset based on month and year partition value
Hi everyone,
I have a table in my database that is updated everymonth and the table has a partition column like 201911 for Nov 2019, 201912 for Dec 2019 and 201001 for Jan 2020. I want to append these values from the table to a Domo dataset every month without duplicates but not sure how to do that using the replacement variable option.
Thanks,
Sivaranjani
Comments
-
Hi Sivaranjani,
If the data you get every month does not have previous months' data then you can follow the steps mentioned below,
- Go to the dataset settings tab
- Under the options, go to scheduling,
- Check for update method, and set it to 'Append'
Doing this, whenever you refresh the dataset, new rows would append to the existing dataset. But if your data contains past months, then duplication may happen.
If your database table is giving out all the months' data then you can go with the 'Replace' option under the same settings as mentioned above and that would clear the domo dataset and will fill it with the incoming data from your database table.
Hope this helps.
Regards
Aditya Jain
'Happy to Help'1 -
If you are not able to use the append method that is available in the Settings section as previously mentioned, you can build a recursive dataflow that would let you append new records to a dataset without duplicating your data. This KB article does a good job explaining it.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 966 Connectors
- 254 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 75 SQL DataFlows
- 499 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 360 Beast Mode
- 19 Variables
- 481 Automate
- 101 Apps
- 376 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive