Magic ETL

1 customer assigned to 2 sales person, how to show the total correctly?
Customer Sales Rep Customer Current Points Balance Bob a 75 Bob b 25 Tina b 125 Jimmy a 65 Above is an example dataset. I have an APP that has 2 filter cards (Customer & Sales Rep) and a single value card showing 'Customer Current Points Balance'. So that when I select: Customer = Bob → then Customer Current Points Balance…
Schedule ETL for Last Day of The Month
We have an ETL that needs to run on the last day of each month. Our current solution is to run the ETL on the 28th, 29th, 30th, and 31st. Can Domo add a default Last Day of the Month option similar to the Last Day of the Month Option in the SFTP scheduling options?
Data Flows - Testing Use Case Filters
Use Case: When building data flows with data sets in millions of rows, it's hard to test if the logic works across those rows unless I add filter tiles that filter out data at specific points during the Data Flow build process. This can add complexity when adding many test cases at specific points. The Idea: It would be…
Search for tile type in Magic ETL
We have some ETLs with hundreds of tiles in them. It would be super helpful to have a way to search for a tile type within a dataflow. The use case I ran into today was, I know that somewhere in this ETL, something is being filtered out. If I could quickly highlight all the filter tiles I could navigate to them quicker and…
👀 Magic ETL Enhancements!! 🚀
Get ready to supercharge your data prep! 🚀 The latest Magic ETL enhancements are here, and they are seriously next-level. 🤯 We're talking freeform SQL for ultimate flexibility, plus new Sections and Generative AI tiles to streamline your dataflows like never before. 🛠️✨ For our beta users, you can even have Magic ETL…
Failed to index using upsert method
Hi, during the initial stage, I had already loaded 6 months of data (hundreds of millions of records) with mapping using Magic ETL. I extracted the raw 6 months of data using Workbench, and Magic ETL connected to this raw dataset to perform the mapping. Upon review, I noticed that I missed mapping one type of document —…
JSON Splits working in ETL preview, but show different results in dataset
Hello! I have created a handful of column splits that preview perfectly in the ELT; however, once I RUN→Dataset, the results are off. Example of JSON FieldValue{attribute=PRIMITIVE, value=Known}, FieldValue{attribute=PRIMITIVE, value=1663001799.0}, FieldValue{attribute=PRIMITIVE, value=100.0},
Why won't my card update?
I have a series of DOMO cards that suddenly refuse to update. The data source, and the DataSet created by the ETL are all updated, but the card refuses to update from the DataSet that is being used by the dashboard. I've done auto updates / manual updates and even though the DataSet itself updates, the card on the…
Magic ETL Join visual feedback (summary of join results)
one thing that i miss deeply from one of the other BI Platforms is getting some idea of what is occurring with a join. right now, to check a join, i have to create several branches of validation to count the nulls, count the rows, check for intersections/mismatch sets, etc. all i really want is when i run preview, it would…
Collapse the bottom section of the Formula Editor window to gain more room in the actual editor
In the Magic ETL Formula Editor window, I would estimate that 95% of the time I don't need any of the bottom three sections: Columns, Functions, and Function Descriptions. With them in place (highlighted in red), and the new AI prompt box which appeared today (highlighted in green), I am only able to see four lines in the…
Timestamp value showing as floating-point: BigQuery to Domo
Hi All I've recently set up a dataset using a MS-SQL connection to Tableau Prep which is cleaned to format the columns for an output to BigQuery which I then use to push the output into the Domo environment In both Tableau Prep and BigQuery my date fields show as follows: Tableau Prep: Date|Time BigQuery: TIMESTAMP But…
Schema and Meta Select Tiles
Does anyone know when and how to use the Schema and MetaSelect tiles in Magic ETL? I searched for documentation and couldn't find any. Thanks in advance for any help with this. Bharath.
"Data Handling" not visible in Config for a Google Sheets Dataset
Hi yall! I'm watching the intro videos on the Domo Youtube channel, and the video on Inputs and Outputs introduced the Data Handling section under the Configuration tab for input datasets in a dataflow. I have a dataflow that changed a column's datatype via a 3-node process, so I thought I would quickly optimize this.…
Exclude null values from Group Concat in Magic ETL
I am trying to use the "group concat" function within the Group By tile in Magic ETL to create a list of IDs that meet some flag condition. If the flag condition is not met, I do not want to include the ID in the concatenated list. From my understanding of MySQL, if a value is null, it should not be included in the grouped…
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.
Show Configuration AND Notes panels on Magic ETL tile simultaneously
Currently, a user can see either the configuration of an ETL tile OR they can tab over to the notes section. It would be nice to see both views at once when writing notes on the configuration or editing the configuration based on the existing notes.
🔍 Tip of the Week #3 – Find Your Columns Like a Pro 📊✨
Working with complex DataFlows in Magic ETL and trying to remember where exactly that column is being used? We’ve all been there—clicking through tile after tile like it’s a memory game. 🧠😅 Good news: Domo’s Column Search has your back! With this feature, you can quickly locate every transformation tile where a specific…
How to split all words in a row, separated by a comma, and append them. The result should be only on
How to split all words in a row, separated by a comma, and append them. The result should be only one column with only one word per row?
✨ Kicking Off Weekly Tips! Tip #1: Master Copy & Paste in Magic ETL 🧩
👋 Hello EMEA Users! I’m Andreina, a data professional passionate about turning complexity into clarity. Over the years, I’ve found that some of the most powerful tricks are also the simplest—and often overlooked. 💡 That’s why I’m launching 🚀 Weekly Tips, a series of short, practical ideas to help you get more out of Domo.…
Hyperlink Text in Comments/Sticky Notes
I'm loving the new comments/sticky notes feature in Magic, including the ability to add hyperlinks. But, right now, you can only add a hyperlink and have it display as the entire URL. As URLs are often long, this causes you to either have very wide comments or forces you to have a scrollable comment. Ideally, you could…
Splitting up multiple-value fields into multiple rows
Hello, I have a dataset like this: ID Num 1 10 2 20, 30 3 40, 50, 60 I want to use Magic ETL to break these out so each row has one "Num": ID Num 1 10 2 20 2 30 3 40 3 50 3 60 Thank you
✨ Kicking Off Weekly Tips! Tip #1: Master Copy & Paste in Magic ETL 🧩
👋 Hello EMEA Users! I’m Andreina, a data professional passionate about turning complexity into clarity. Over the years, I’ve found that some of the most powerful tricks are also the simplest—and often overlooked. 💡 That’s why I’m launching 🚀 Weekly Tips, a series of short, practical ideas to help you get more out of Domo.…
WEEKOFYEAR is not aligning to ISO-8601, is this correct?
Hi, I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. . Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function. Best, Sam
Search Columns on ETL preview
It will be amazing if we can have a way to search / filter columns on the etl preview. Same way than in the data tab 🙂. Sometimes we have a LOT of columns and the only way to preview a specific column is adding a Select Tile.
Magic ETL Won't Save DataFlow?
Team, I have built an extensive ETL and I want to "Save and Run" to explore and analyze the output. Unfortunately, the "Save" button isn't responsive. I will click on it and it won't actually save. I'll click "Save and Run" and it won't actually save… Weird issue that I've never ran into before so hoping there's a simple…
CTRL + Z undo in Magic ETL
Love the new undo/redo in Magic! Would love to have undo/redo keyboard shortcuts.
History Keyboard Shortcuts for Undo and Redo
It would be very helpful to navigate the new history with Ctrl + Z and Ctrl + Y for Windows and Command + Z and Command + Shift + Z for MacOS for undo and redo actions.
Smaller Sticky Notes
Allow sticky notes to be two grid spaces tall and two wide (currently they can't be smaller than three tall and three wide). This would allow for notes the same size as tiles, which is great for placeholders.
Duplicate Sticky Notes
Add a way to duplicate a sticky note. Having to restyle a note every time I create one is tedious. If I want the same style of note (which I often do), being able to duplicate and just change a few things like the text would be very convenient.
Consistent Colors for Sections
The colors for sections differ across the picker bar, the selected icon, and the section background. Not a huge thing TBH, but it does trip me up a bit when I don't get the same color I pick. The selected color icon I understand a bit more, as otherwise it would blend with the background.

Magic ETL

Discussion List