Ask Magic ETL questions and get answers from Domo peers
Hi, I'm having an issue. I want to split the fruit column by comma then alphabetize, then bring them back together on their respective account ID. How would I do that in magicETL?
I have data showing the start and end date, such as the below. I want to use a chart to show starts & ends side by side by week. Is this doable with a ETL or beast mode? CandidateName CompanyName StartDate ActualEndDate Name1 Company1 12/23/2024 Name2 Company2 12/23/2024 Name3 Company3 12/23/2024 Name4 Company4 12/23/2024…
I want to create a dimensional variable that allows users to choose between WoW, MoM, QoQ, and YoY using the chart types below. What is the best way to go about this? Any tips on creating the ETL to create the components above?
Community, My data is formatted per my example screenshot below. Is it best to pivot each location into rows, or is there a benefit to maintaining columns for rows? I will need a total number, and then drill down numbers (I.e. Total Net Profit = 30 > Drill Down > Omaha Net Profit = 10)
How would I remove the loans that have a PaymentInFullDate associated with them? Can this be done with magic ETL?
I am currently struggling to find a cohesive solution to being able to fill nulls with the first instance of a non-null value. The layout is very simple, basically there is column called ID and it contains one non-value null and the rest is null until the next non-value null. I would like it where the nulls are replaced by…
Hello, I am currently testing out Upsert for the Update Method of the output dataset and I am confused about how it functions. From what I understand, it serves as both an append and replace update method where you can append on the current data to the historical data that exists. The issue I am facing is that I wanted to…
Hi, I am seeing reference to a Writeback Tile option in the Datasets section of Magic ETL in Domo documentation. I don't have this option or see refences to it anywhere else (forum etc). Anyone here know anything about it? Eg:
Hello! I am trying to edit an ETL with three input datasets.. My goal is to get the 'GLAcct' row of data from the "GLAC PARTS (EZ TEST)' input dataset into the GLBD_V2 datset. Currently, the join is taking the 'GLAcct' under the input dataset 'GLBD_v2'. The request I received was to add a column onto one of our cards…
Hello, I have a Magic ETL that provides open order data based on an item number. One issue I am facing is if I have two or more types of open orders for an item, then they will cross multiply. For reference, I have 3 open internal requisitions and 3 open sales orders for 1 item. Instead of displaying 6 rows (3 IR and 3…
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