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
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
You're only one dashboard away.
Click here for more video solutions:
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
You're only one dashboard away.
Click here for more video solutions:
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
You're only one dashboard away.
Click here for more video solutions:
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive