Ask Magic ETL questions and get answers from Domo peers
Hi, I am working on taking some mySQL dataflows we have stored and turning them into MagicETL dataflows. I am wondering, does anyone know of an 'order by' function in ETL that is applicable? TIA
Hello, I am trying to take the data below and make the 'ORDQTY' column multiple rows based on Columns C and T and U. How would I do this? The end goal would be for row 2 would have two identical rows since there are a quantity of 2. Row 7 would have 4 identical rows and so-on. I am trying to have 1 unique row based on…
Hi, I have a dataset that I have grouped together into monthly data (using the LAST_DAY function in case it matters). Using magic ETL, I then add the forecasting tile to get a forecasted volume. I have actuals upto the end of May 2022, but the forecast model is only giving me forecast data starting in July 2022. Can…
The short version, I need the following query to work somewhere in DOMO ETL: AVG(`Score`) OVER (PARTITION BY Company ORDER BY 'Date` RANGE BETWEEN INTERVAL '90' DAY PRECEDING AND INTERVAL '0' DAY FOLLOWING) More detail: I tried using group by but cannot use window functions, formulas but can't use aggregations, and rank…
I currently have an ETL looking at distinct Opportunities by their close won day. However, this issue is now looking at Distinct accounts within the same dataset. At first, I thought to use the count distinct function on the account ID in a groupby. However, since multiple opps can be tied to one account and each one can…
I have a dataflow that I only want to start when the data in a dataset materially changes. It seems like it runs no matter if the data changes or not. Any advice on this.
Hey there! I am trying to alter a text into a date, but I keep getting the "failed to parse" warning. For context, I'm uploading a CSV file. Does anyone know a formula to fix this? I've tried multiple, but haven't had much luck. *I provided a screenshot of how the field looks in the CSV file prior to uploading into Domo.
Hi, I am facing below error while executing magic ETL flow in Domo. Failed while executing "Failed to index DataSet '3a922bde-7139-42c1-96c3-88d7516a1fa7' " All tiles were executed successfully, but output dataset is not created. I used "upsert" as update method for creating output Dataset. Could you please suggest to…
Hey there! So, I am trying to alter a text into a floating decimal but I keep getting the "failed to parse" warning. For context, I'm uploading a CSV file that already has the field I'm needing as a currency. But, when I upload into Domo it turns it into a text. I will be needing to aggregate (sum) this field so I need it…
Hello, Is there any way to import a dataset created in Power BI (via Power Query) into Domo as a dataset? For example, my organization uses a Data Warehouse (other than domo). The Finance group, which uses Power BI performs transformations on the data from the Data Warehouse. I would like to use the 'processed' datasets in…
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications