I have rows of data that look like this: Customer: ID: 12 NULL 12 NULL 12 NULL 12 NULL 12 NULL 12 56 How do I fill in the above rows with the customer ID, 56, Using ETL?
I am trying to create a writeback connector. The SFTP instruction indicates I need to create and upload a public key to FileZilla. However, there is no place to upload a file in Domo. I wonder if there is a workaround?
Hi all! I'm back with more beginner level questions probably :) I feel like I've done the complex piece for this which is writing 24 different Beast Modes. I'm just struggling with which Actions to use in the ETL to bring all these Beast Modes together at once. This looks like a fairly useless mockup because there's no…
Is it possible to add fixed functions in the magic etl? This is the fixed function I'm referring to. SUM(SUM(Term length (lookup)) FIXED (BY Document Number)) I can add it in as a beast mode, but can't add it as a formula in magic etl.
Hi all, First time posting here, and I'm just looking for some guidance on if this is even possible. Any help is greatly appreciated! We have created a report in Domo that is using 3 separate cards, all from the same dataset. Each card has a different "Total" because in Analyzer, there are various factors filtered out. In…
I have an ETL that is scheduled to update once per day, but every time it runs automatically, I get a failure after about 10 seconds stating: "Failed while executing. Illegal number of inputs. Expected one but got zero." I usually can rerun it around 2-3 times manually and then it works. There are no errors that I can see…
First off, I'm a Domo newbie, only been working with the program for a couple of months now. I discovered an issue with an ETL I've been working on that uses a colleague's data set as an initial input. The source table itself is updating just fine, showing recent data. But when I look at the input data source, I only show…
Hi Community, I am struggling with combining two data set like below As you can see we have one campaign but has many views. When I combine these two, spend would get allocated to all the rows in table 1. How can I join these two table without overcounting the data on table 2?
Hi - I'm trying to figure out the SQL code to sum (A) bill rate + (B) bill adjustment = Total Bill. However, Bill Rate can either be (A1) Original Bill Rate or (A2) Posted Bill Rate. Similarly, Bill Adjustment can either be (B1) Original Bill Adj or (B2) Posted Bill Adj. Logic is that If the (A2)Posted Bill Rate is NULL,…
I have a dataset that represents order information. Each row is a unique order ID. One of the column values shows the quantity. I would like to duplicate (or replicate) the rows based on the value in the quantity field. Example OrderID 12345 has a Quantity value of 5, so in the output dataset, I want 5 replicated rows for…
It looks like you're new here. Sign in or register to get started.