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 to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive