Hi, I was editing my ETL and removed the output dataset part and had saved by accident. How do I add the output back in as it seems to just recreate a fresh dataset with the same name rather than write to the existing one. Thanks
Hello, I am trying to write an ETL which sums a value based on the grouping in another column (invoice number) which yields a column with the total quantity for each invoice. i have attached a simple table as an illustration of what i am looking to achieve. I do not want to write a formula where i have to continually…
Hi there, Is there a way to combine values in multiple columns except when the value is null? For example: This is a small example, I need to combine 8 different columns with a separator without ending up with: cat, , , , , orange, . I'm essentially looking for a DOMO equivalent of TEXTJOIN() in Excel. The values don't…
This idea was mentioned towards the bottom of this thread by @MattGo and then @StevenC mentioned that it was a good idea back in 2017. Would save us a lot of time and add a lot of value.
I have a current dataflow that is recursive. I want to make sure the company records that are being snapshotted are. I am planning to use a field "Snapshot Date" which is the current date timestamp on the recursive. How would I go about assuring the companies are being snapshotted daily in the ETL? Would I need to match…
Hi guys, I have dataset that gets created as part of an ETL. I would like to take a copy of this data remap one of the columns and then append it to the original set. Something like below. So take the data add a customer Id column default to say 1. Duplicate the data. Remap the customer Id column to something else and…
My goal is to filter all times between the hours of 9PM-5AM, but the data in my field looks like this: 2021-12-31T21:20:49 How would I trim this field to get the time exclusively and possibly convert it to 12-hour format? Thank you for your help
I'd like to create a new dataflow, preferably not MySQL, to show that the fields I intend to snapshot daily are actually being snapshotted. For more context, I have a list of companies with subscription updates that are currently being snapshotted, but I want to ensure that everyday, every company is included. Anyone have…
I have a dataset with chunks of bad data in it. To get a MFG date I pulled the first 6 digits of the serial # to get a "date" in an text format. if the data is correct it should read out the correct date, but in some cases the data will have 06B378 or other letters or texts that should not be in there. How would I go about…
I dataset with a list of "pulls" for each day and the "setter" associated with that pull. I have a calculation through the ETL for this dataset that sums up the total sales per setter for the previous 30 days. My objective is to count the number of distinct setters who have a sum of 0 total sales for the time range…
It looks like you're new here. Sign in or register to get started.