I need help implementing a particular use case for partitions: importing selected partitions from a dataset, modifying the records, then outputting the data back into it's original partition (or a new partition) in the original dataset. There are two uses for this I can think of off the bat: A dataset can have a maximum of…
Hello all, I have the below workflow in my Magic ETL. Just posting a sample version below. My question is - I have a ProductID that I join from both the data sources and then do a group by and output to a file. But I also need to know Total count of Product ID or row count from TEST spreadsheet source. Is there a way I…
Hello all, I am non-technical, non-SQL speaker trying to figure out DATEDIFF. My problem 1. In Domo, I have a date that looks like this:10/17/2019 11:06:45 AM (this is a 'date' field in my table) 2. I'd like to add a calculated field that counts how many day from "today" it is. Can someone send me the Datediff statement I…
Hey everyone - first post here! Curious if anyone is using GA4 data stored in BigQuery inside Domo, and if so, are you unnesting things after connecting to BigQuery, or are you doing that in BigQuery as a pre-process step? Any best practices to share would be very much appreciated!
I'm looking for a breakdown of the conditions required for the substring functions. Thanks!
Hi, I need your help, my brain is frozen…;) I am reporting on Support Cases in Salesforce. Every day, I pull a report into Domo showing all cases per Case Record Type that are open that day. E.g. report pulled 6/9/23 says for CRT Support A 24 Open Cases and for CRT Support B 37 report pulled 6/8/2023 says CRT Support A 12…
I have data that I snapshot daily. It has employee name and employee status. Once the status gets updated, it remains that way: ex for one employee: 1/1 Name: active 1/2 Name: active 1/3 Name: active 1/4 Name: Inactive 1/5 Name: Inactive 1/6 Name: Inactive 1/7: Name: Inactive At the card level, I would like to be able to…
I have a data flow that has multiple properties and competitors. I was looking for a way to label all of the records that are in between into one property. In the example sheet that i uploaded, I was wondering if a beast mode formula could be used to rows 3-16 are labeled as the property Brandon crossroads in this case.…
I have these columns and I would like to sum the cost column only when the Publication and Year column have duplicates, so I can see the cost per Publication per year. Brain fart, I am assuming this is pretty straight forward? I'd like to do it in ETL if possible. Is there some SQL I can utilize to do this in the formula…
I'm using Magic ETL to create a new column that will return True or False depending on the contents of a string in another column. Question is how do I write a Case formula that will return True or False based on the contents of another column? For example, the word "Delivery" is placed in different locations on a string…
It looks like you're new here. Sign in or register to get started.