Cards, Dashboards, Stories
Cards, Dashboards, Stories
Appending data when using Connector with Sql Query
Hi, have a quick question about a Workbench module on our Historian server. I'm running a query automatically every evening to update my Domo Dashboard (USCB Alarm Management Dashboard) with the data from the previous day. I'm querying the previous 24 hours. I'm appending the dataset.
My question is a foundational one related to the appending. I want to ensure I'm not adding data to the the dataset that already exists. I've attached my query and configurations here.
Thanks,
John Whited
Welcome!
Best Answer
-
Hi @John_Whited ,
First, love meeting other Johns with an H in their name. Jon's are untrustworthy.
Second, I made a quick video for you with a possible solution:
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0
Answers
-
Hi @John_Whited ,
First, love meeting other Johns with an H in their name. Jon's are untrustworthy.
Second, I made a quick video for you with a possible solution:
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
Thanks so much! This is great! I'm going to try to follow this. I'm new to Domo. The Workbench is the module from Domo that installs on my machine. The Connector is OBDC. I put the transform in. (My first transform). I need you to be my friend! I'll be hitting you and your services up.
Thanks,
John Whited
+1 (740) 260-4569
1 -
As a fellow John with an H I would love to be friends!!! Also, I have courses on Domo so feel free to signup for a free 14 day trial:
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
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