Appending data when using Connector with Sql Query

John_Whited

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.

Domo, Workbench, Config, 01292024.JPG

Domo, Workbench, Query in Notepad, 01292024.JPG

Domo, Workbench, Query Section 1, 01292024.JPG

Domo, Workbench, Query Section 2, 01292024.JPG

Domo, Workbench, Schedule, 01292024.JPG

Domo, Workbench, Schema, 01292024.JPG

Thanks,

John Whited

DashboardDude

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: https://www.loom.com/share/059d3eee646d4d8da6580e809886e56e?sid=28f0695d-1600-46dd-a023-9348649b0961

DashboardDude

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: https://www.loom.com/share/059d3eee646d4d8da6580e809886e56e?sid=28f0695d-1600-46dd-a023-9348649b0961

John_Whited

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

DashboardDude

@John_Whited

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: https://www.dashboarddudes.com/