-
ETL Fails = "Illegal Number of Inputs"
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…
-
Point ETL Output to Existing Dataset
I want to be able to point the output of an ETL to a pre-existing dataset. If, as part of a fix or as part of development, I need to make alterations to the ETL to get a desired output that I don't want to be the final ETL, it would be great to be able to make the changes and then point the final ETL to the preexisting…
-
Fill in gaps in data
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?
-
Have Domo GPT help with ETL errors
I just spent 30 minutes in an ETL trying to figure out what was wrong. I get the basic errors like "Failed to turn a string into a date", but when I open the ETL and see which tile the error occurs in, I have no clue which specific formula or row is causing the issue. Especially because I will open the root datasources and…
-
Undo button in Magic ETL
The addition of the undo button in the Analzyer has been extremely helpful. I would ask that an undo button be added to Magic ETL as well. This would help people who accidentally delete a tile that had a lot of configuration in it. Or if you made a number of changes that don't work and you want to step backwards to get…
-
Combine 2 data set (One to many)
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?
-
How to Duplicate Rows
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…
-
size of dataset
Is there a way in Domo to understand the actual size of the dataset? I know we can find the row count, but I am not sure how to find the size in GB/TB.
-
Many rows
I need to find a way to pull in many rows of data. I have two months worth of data which is essentially 110M rows. I need to pull in at least a year. Is there a way to do this? I tried the ETL partitioning method but it said 'too many rows of data'. Would workbench work with partitioning here or would I get the same error?…
-
Allow Group Ownership of Magic ETLs in DOMO
Currently only Datasets can have group ownership, however it would be a great timesaver if a group can have ownership of an ETL in Domo. It would make ownership more streamlined and controlled.
-
Sub-Category of a Category?
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
-
Logic - link original submit date to all subsequent back orders
Hello. I'm wondering if anyone has ever had a similar scenario/concept and have come up with good ways to achieve the desired outcome. I've attached a screen shot of real data. The goal is to get the submitted date of 7/5/2024 (A6) linked to orders in rows 7 and 8. The story of this data is that order id 16403748 was…
-
How to Use Partitioning to Retain Data in a Monthly Rolling Window Dataset
Hi Domo Community, I’m currently working with a dataset (via MongoDB Connector) that operates on a 12-month rolling window, where data older than 12 months is deleted on the 1st of each month. Long story short, I cannot change this configuration. But, I would like to retain some of this older data using partitioning before…
-
Extract the string values in between stroke and question mark in a URL
Hi Domo, I am looking for a way to extract the string values in between stroke and question mark in a URL Example URL: https://dam-bc.com/content/67-making-AI-trustable.pdf?_gl=1*ckt29z I want to extract this part of URL: "67-making-AI-trustable.pdf" Ideally if I can do that with a beast mode formula would be great. But if…
-
COLUMN NAME CHANGE - PUSH TO BEASTMODES / BEASTMODE SEARCH AND REPLACE
I think a good option would be that if a column name is changed in the Column select tile that if that old column is being used in beastmodes that we can push that change to all affected beastmodes. When managing 100's or thousands of beastmodes it makes it difficult to go back and correct if we have to change a column…
-
Selecting prefix for conflicting field names
When joining datasets, Domo alerts you to any conflicts in the naming. Specifically, any common field names have to be renamed. It defaults to using the name of the originating dataset as a prefix. We use longish, descriptive dataset names, and the narrow, static width of the editing line makes renaming very tedious. Is…
-
Templated ETLs
I would love to be able to create an ETL and save that to use in other flows. A "save as template" button would be amazing. It would only save the tiles, not the columns, so you wouldn't have to delete everything before you start. We use recursive dataflows a lot, so it would be amazing if I could save that flow, and then…
-
MagicETL Recipes
We all have ETLs where we use common logic over and over again. I propose an idea to enhance MagicETL with something called 'Recipes'. A user could create a new recipe within Magic, add a series of tiles into it that do some common logical steps and save it with a given name (e.g.. 'Strip Whitespace and Split String'. Once…
-
How to create YTD, LYTD, LYLW, etc columns from a FISCAL CALENDAR
I have a dataset that has sales per item going by each week (yyyyww) for the last three years, only I can't use things like YEAR(CURDATE()) or YEARWEEK(CURDATE()) because the yearweek we're getting from the dataset is based on a fiscal calendar (Ex: The first full week of august is the first week of the year, so July 29,…
-
Company Turnover %
I am trying to calculate the company turn over %. We are pulling data from Salesforce into Domo. We have a custom object that lists all employees. These employee have an active/inactive status and a termination date. I am trying to figure out a way to calculate the total ACTIVE by INACTIVE YTD based on that term date.…
-
Pivoting into multiple columns
My dataset has a Month column. I want to pivot the data so that the months become the columns (so a column for June 2024, a column for July 2024, etc). Using the Magic ETL pivot tile it seems I'd have to perform the pivot for each month separately. Before I go down that route, does anyone know an easier way to do this?…
-
Magic ETL Join Tile
Apologies if this has been requested in the past. I would like a case insensitivity checkbox on the join tile. In the example below, I have created two datasets. In dataset2, I have a list of words in varying cases: lower, upper, and proper. If I join the datasets, I get different results based whether the words in…
-
Duplicate column feature name change in Magic ETL
The current duplicate column title is a bit confusing. I thought it would create another similar duplicate column like the existing one. However, it only replaces the values of an existing column. It would be nice if you could also allow someone to create a duplicate column without affecting the existing columns.
-
Pivoting multiple columns with the same column values as its values
I have a scenario where I have rows from multiple columns that I want to pivot into a multiple columns. Let's say I have three columns: 'Questions,' 'Labels,' and 'Values.' I tried pivoting the 'Questions' column into separate columns with values from the 'Values' column. Now, I also want to pivot the 'Labels' column into…
-
Changing the input datasource to multiple ETLs at once
I have a table that powers multiple ETLs and I want to change this table in all the ETLs to another table without changing it individually in each ETL. Is there a way I can do this or view what ETLs are powered via Domostats ( I know I can check this in the Lineage tab) but I want it in a table so that I can analyze the…
-
Annotate part of an ETL dataflow
Is there a way to annotate part of an ETL dataflow like the following
-
How to get Gross Sales from Shopify?
My team and I are in the process of building datasets from Shopify's API but we are not able to get the gross sales amount to match with the gross sales amount in the Shopify's dashboard. Does anyone have any insights on this? We selected the report "All Orders". We have played with all columns, total_price,…
-
Where is my data going??
My data seems to be disappearing between the ETL and the final data that it actually outputs. Here are some pictures to try to explain what's happening. The first image shows the preview on the final tile in the workflow (being the output file titled Work Numbers (Final)). The second image shows the same chunk of data,…
-
Dynamic Pivot
I have a table with a combination of fields and a target value. I want to concat all the fields (Retailer, Field, Target, Strategic Priority) and pivot the table so they are all columns with their respective Target Value underneath. I know how to do this with the Pivot option in which I manually create a new column for…
-
Form Builder and Form Viewer Transformation
I am trying to use submissions we get from forms in DOMO via form viewer/builder apps and turn them into usable datasets that we can create cards with. Right now the form submission data puts the label in one column and the value in another and I would like to make it where the data looks like this: Date: | Model: |…