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
Let me make you the me of your organization for Domo
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
Let me make you the me of your organization for Domo
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
Let me make you the me of your organization for Domo
Click here for more video solutions:
0
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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive