-
Easy dataset field width extension
Hello, We often use Domo datasets to store responses from our LLMs and need a way to easily extend the width of the response column beyond 1,024 characters. Currently this requires working with the Domo engineering team. Is it possible to bypass that process and manage column widths directly in Domo? Perhaps in the…
-
HTTP Magic ETL TIle
Hi, I remember seeing a new HTTP tile for MagicETL being mentioned during Domopolooza that should allow us to fetch data from API sources directly in MagicETL. I realize the feature isn't out yet but it makes me wonder… My question is, will this feature allow hitting internal domo API's? I can see a TON of use cases for…
-
Previous Month with Lag Window Function?
I have a sample dataset like this: MonthEndDate Amount Aug, 2025 80 July, 2025 70 June, 2025 60 And I'd like to have another column called "Previous Month", but I'm not sure how to set that column up with Rank & Window tile in magic ETL? MonthEndDate Amount PreviousMonth Aug, 2025 80 70 July, 2025 70 60 June, 2025 60
-
Dataflow Certification Expiration
It would be nice to make dataflow certifications expire if a certified input dataset expires since the inputs affect the outputs. Currently dataflows only expire when you change the schema within Magic ETL. If input datasets are certified and lose their certification due to configuration changes, the dataflow keeps it's…
-
Ever wished you had more space in the formula editor?
The days of trying to construct a long and complicated formula in an itty bitty little formula editor are over - you asked and we heard you: we've now added the ability to collapse the Tools section of the expanded formula editor in Magic ETL. This went live in your Domo instance yesterday. Just open the expanded formula…
-
Pivot Data
Hi, I've table like the one below and I would like to pivot it as the output table shown below. The Pivot function in Magic ETL is asking for row identifier column which I dont have in this case. Is there any way to achieve the result? Input: <!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}--> Column…
-
Ability to disable tiles in Magic ETL
Often when I am building out a new Magic ETL or troubleshooting a bug I will add a filter and a test output so I can better isolate the data. To do this I have to keep the existing flow intact so that I am able to run the ETL. It would be very helpful to just disable a portion so that I don't have to deal with a long run…
-
Inventory Waterfall Report
Trying to build a inventory waterfall report in DOMO, and thinking i need to start with a Magic ETL. The goal is to show the starting inventory value for the month and the ending inv value for the month. There are different inputs and outputs to the inventory value through out the month. I have a ending Inventory value…
-
8/7 Product Release: Filtering, AI agent 2.0, Navigation, Clonse DataSet, Magic ETL and MORE
Watch quick videos highlighting some of Domo's newest feature enhancements [8/7 release]. Filter & Variable enhancements We’ve updated filters and variables within Domo’s apps and dashboards based on your feedback! Date variables now support 'today' and other relative dates. Also, you can exclude the current period from…
-
Conversion - String Field to Integer
Hi, I have two datasets that are to be joined by a unique field. Issue is that in one dataset that field is an Integer whilst in the other it is a String. The Join type is 'Left Order' so it is picking the data from the left table but not from right. Can you guide me on how to achieve this / fix this? Can it be done on the…
-
Magic ETL Field Search Tile Highlight Enhacement
While I do love the new Magic ETL field name search, what would make it even better is if there were a way to highlight the tiles where the searched field is actually modified (vs. just passing through). It might just be me, but if you would find this useful, give this idea some love :)
-
SQL Tile Limitations?
Hey! I'm attempting to replace existing magicetl logic in one sql tile. :) I'm having issues though. I want to replicate this very easy grouping then inner join. Does the SQL tile support this grouping ability?
-
🚀 Tip of the Week #12 – Beast Mode vs Magic ETL: Choose Smart, Work Smart 💡
*Thanks to @ajay_p for bringing this topic to the table! 💡* Choosing between a Beast Mode formula or building the logic into Magic ETL depends on the context, how reusable the logic needs to be, and performance considerations. Here's a quick guide to help you decide the best path: 🧠 Beast Mode = quick, dynamic calculations…
-
Recursive calculation in domo etl
Hello Team, In my dataset i have a task to calculate the forecast value when the revenue is null for the current month. The forecast can be calculated by the formula which is Previous month revenue + previous month revenue * variance. However when the previous month revenue is null then I want the forecast value to be the…
-
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…
-
Magic ETL Flow Error:
Hello Community Team, I'm encountering another issue while trying to save a workflow—an error message appears during the save process (see attached screenshot). As shown, my dataset is configured within the same compute integration, so it's unclear why this error persists Regards, Ritesh
-
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…