Community Forums

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

Recent Discussions

Validating datasets that has different formats
I need to validate 2 finance datasets to ensure the numbers match for all GL accounts. Dataset A: Columns: Account_name, Branch_id, MTD, MTD Budget, MTD Last Year, YTD, YTD Budget, YTD Last Year. This dataset is generated monthly from the ERP system, with pre-calculated values. I need to append it each month after adding…
Magic ETL: EJ Group
In this quick tutorial, I share how to convert Redshift queries into Magic ETL with a single click. I demonstrate how to seamlessly transition complex SQL code into Domo’s intuitive ETL tiles, with minimal adjustments. This tool has significantly streamlined our workflows, reducing Redshift processes from 89 to just 27—an…
Magic ETL: Butler AR
Unlike other tools I've used, Domo makes it easy to combine data from various sources—SQL databases, Excel sheets, APIs—and transform it to deliver relevant insights. This feature has been invaluable for providing the exact answers my team needs to drive company decisions efficiently. Use case
Group By Issue
I need assistance with identifying transactions that net out to zero in a large dataset. Each row in the dataset represents a unique transaction with its own ID. Objective: Identify pairs of transactions that meet the following conditions: Same client ID Same transaction type ID Same transaction date The sum of their…
MagicETL Transform Settings: Timestamp to Date
I can't seem to find a clear answer as to what is happening here, so I'm turning to the community. I have a dataset with a timestamp field, createdAt The dataset arrives to Domo in UTC, and my company timezone settings are converting it to USA\Eastern Time. This is working as expected. Using this as an input dataset in…
Input DataSet - Load New data
I am working on a new dataflow using Magic ETL. I have 11 input datasets. All are Workbench jobs with the Update method set to Append and they each have an assigned Upsert Key. I have configured each of the inputs to load New data. When I save my dataflow 3 of the 11 throw an error. "This data set does not support data…
Case when and formula with date
I'm writing the following formula and it's not distinguishing between the dates correctly. What am I doing wrong? case when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then `Total referrals` = 0 ELSE `Total referrals` end Note, my date shows as the little calendar and 'Total referrals'…
Group two datasets and join them
I have two excel files one includes sales data and line items of products sold in each invoice, the other sheet I have is the freight charges per invoice. I want to be able to sum the freight and sales totals on both sheets and group them by the invoice number on a combined sheet. Is this possible? I sort of started with…
Filtering and Adjusting Cross-Month Records in MagicETL
Hey Domo Dojo Community, I'm working with a dataset containing reservation start (RSD) and end (RED) dates in the format of MM/DD/YYYY. I need to identify all records where the reservation spans across two different months (i.e., RSD and RED fall in different months or years). My objective is to filter out these…
Transform Your Dataflows: Discover Magic ETL's Latest Upgrades
Are your data pipelines working as efficiently as they could be? With the latest updates in Magic ETL, there’s never been a better time to fine-tune your processes. Join us on November 21st for a special webinar where we’ll showcase new features designed to help you optimize your dataflows, enhance accuracy, and boost…

Welcome!

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