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.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 559 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 574 Beast Mode
- 12 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 355 Distribute
- 94 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive