Ask Magic ETL questions and get answers from Domo peers
I noticed there is a difference between ordering using Rank format on a card, and using the Rank tile in a dataflow. If you use Show value as 'Ranks small to large', whenever there is a tie, the following ranked item will remain incremented by one. But when using the Rank tile, after a tie, the consecutive numbers are…
I am trying to join an ETL, but for the life of me cannot get the join to work. I have double and triple checked that the columns are formatted the same, trimmed on both sides just in case, etc and Magic ETL still won't recognize that the data matches. What should I do?
I'm in need of a formula that will allow me to pull only the LAST four weeks of "Ship Date" data so I can get a weekly sales average from said data. I've tried a few variations of trying to use the INTERVAL function paired with < = to no avail. I need to then take the sales average acquired from the above task and assign a…
Hi, I have a dataset with null values and text and I am trying to replace them with 0 and 1 respectively. But, when I try to write a formula using the conditions 'If Null' or 'If not null' I keep getting errors. Does anyone have any ideas? Thanks! Edit: I figured out what I was doing wrong.
Hi, Just to help any one that runs into the same problem. I noticed tonight that TIMESTAMP columns with times set to 12:00:00am no longer join to DATE columns. This changed some time today. I have had to adjust the column within the ETL in the data handling section of the input. Luckily there was only a handful of sources…
Hello - does anyone know how to write an ETL formula to extract the numeric ID at the end of this campaign name: Display_Retargeting Package_07/09/24-12/31/24_BA:4114356 so that I can get a new column with just the campaign ID? Thank you so so much for any help!
Hello - does anyone know how to write an ETL formula to extract the numeric ID at the end of this campaign name: Display_Retargeting Package_07/09/24-12/31/24_BA:4114356 so that I can get a new column with just the campaign ID (numeric string at the end of the campaign name 4114356? Thank you so so much for any help!
We are working on building out our backend in DOMO and are trying to build a relational database instead of having individual queries for everything. We are connected to NetSuite through Analytics Connect. The raw table we are bringing in has columns for employee, service tech, service manager, etc. In NetSuite, these all…
Hi all, I am working in magic ETL and I have a dataset that gets appended each month. Most of the data is useless for what I am trying to use, except for the latest month's set of data. Is there a tile in Magic ETL that lets me filter out by latest date? I believe I could use a rank and order but am trying to not use…
I have web app that will not share data. No APIs, not even export capabilities. I could use some help with ideas of how to make this work. Here is what the website looks like on the website: And Attached is an excel file where I highlighted and copied the data into an excel sheet in three different way (Paste, Paste…
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