Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Delete the most recent update on an existing dataset?
I loaded in a dataset A → Settings → bring in dataset B, Update method: replace (it's supposed to be append). So now I need to delete the most recent update, but I don't have that option since I'm not the Admin. I remember someone answered in a community post saying that in you can add some text into the Dataset History…
Best updating/appending method for sales records?
So I need to append new sales records every end of month. The sales records are stored as Excel Sheet with these columns: Order Date, Product ID, Customer ID, Sales Amount, Unit Price, Qty, Ship Date. So normally I would just go to the dataset → setting → upload new month dataset in → updating method: append Just wondering…
Adding source column in appended datasets using Magic ETL
Hello, I am trying to append a 8 datasets together and add a new column to the resulting output that is the source dataset for that row. That column is obviously not present in the original dataset. I just need to know where the data for that row originated so I can filter if needed. I have tried a few things but cannot…
Truncate Appended Domo Workbench Dataset
We have some datasets on our Domo Workbench setup as Appends. They have grown very large over time as they take a snapshot of the data daily. The datasets are still used but we no longer need the complete history. We would like to do something like keep the last 2 years or maybe keep one reading per month or something…
Handling "Replace vs. Append" Logic with Email Connector
Hello everyone, I'm seeking advice on configuring the Domo Email Connector for importing reports in a "month-to-date" format via email attachments. I want to a) retain the reports for previous months, but also b) replace the latest "month-to-date" report. Our goal is to achieve a combination of "Replace" and "Append" logic…
Find and append a value to a field
I'm trying to align some inconsistencies with our data. What I'd like to do is find any value that does not end with a '/' and append it with that character. Is there a case statement where we can look for a field that does or does not end in a character? I assume if I can do that, I can just append those without with the…
Appends Should Default to Include All Rows
Appends should default to "Include All Rows" and not change every time inputs are added/removed. Huge quality of life upgrade!
Combining two datasets based on two potential fields
Hi, I have two datasets. One has pacing data, the other has monthly data. All rows have unique IDs, however the pacing data may have either an ID from the old system (legacy ID) or the new system (new ID). Pacing: ID 1 2 3 4 11 Monthly: New ID Legacy ID 10 1 11 12 13 2 14 3 15 How would I go about joining these two…
Issues Joining Transaction Details to Primary Dataset
I have two datasets. One is structured as the "primary" expense file, where each row is dates and other dimensions for each credit/debit. The next is credit card transaction details. They share transaction IDs in a column named Doc, share GL #'s, and share posted dates. The combination of all 3 of these things will result…
Selecting only newer records from a remote datasource to append to a Domo datasource
Hi here… When setting up a query to grab data from a remote datasource and append to data in DOMO. Is there a way to grab newer records based on the data that was previously imported. Page: DATA / <DATASET NAME> / SETTINGS / QUERY I'd like to run something like: SELECT * FROM myRemoteDataSchema.myDataSet ← remote dataset…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.