👋 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 ofte…
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 ofte…
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
👋 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 ofte…
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 s…
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 colum…
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'…
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.
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 place…
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 th…
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 sele…
I am attempting to create a workflow where a form is began to define expense categories, the responses are recorded by a manager, then the responses automatically update the budget dataset in an ETL p…
HI Team, I have a date field and what I'm trying to do is write a beastmode that looks at YTD and MTD without years. I have successfully done that in 2 separate beastmodes to give my a 'Y' or 'N' togg…
An ETL can have several workstreams. We may have a workstream we do not want to remove, but do not want running anymore. Today this is a challenge solved with copy or versioning, but what if you could…
The ability to select specific blocks to run as a preview. Case: In an ETL we have several workstreams and outputs. I want to be able to select a specific area to exclude or include from a preview. Co…
Just had a user accidentally do a join that we identified 7 hrs after the process started that was up to 72 billion rows. It was going to top out over 300 billion, but we hit cancel. However, that ove…
Greetings, I would like to propose the addition of a tile that enables early termination of a dataflow without writing to the output dataset when specific conditions are met. A key use case for this f…
Hi, I want to replicate a table that looks like this: My dataset currently has date, impressions, and goal, and in ETL I've mapped the dates to a week by joining with another table. How would I use be…
Hi Everyone I'm trying to calculate a sum of values for the previous month for the previous year (February 2024 in this case) so that I can compare the difference to previous month for this year I've …
When using the 'Select Columns' feature with a dataset that has many columns, it becomes a time-consuming process to search for and add each column individually. It would be incredibly helpful if we c…
The ability to turn on Larger Grid and Grid Lines to all of a user's ETLs (my preference) or user selected ETLs in Magic. Currently users have to do this ETL by ETL. My belief is that if a user wants …
Hi, I have a dataset of about 4.7M rows. When I try to use the Group By tile in Magic ETL to find a sum of values across IDs, and then join back on the ID, the new sum column is blank. However, in tes…
Please add an option to manually reorder columns in the Select Columns tile by entering an integer position value next to each column—similar to reordering mechanisms seen in interfaces like Steam’s W…
When building complex ETLs it would be handy to be able to "comment out" tiles so they are ignored for execution. For bonus points, I'd like to be able to have an unterminated chain of commented-out t…
The Dataflow schedule has a setting to trigger when input datasets have updated. It would be helpful if there was a way to schedule it run at a certain time if an input has not updated. There are occa…
Please add: Automatic identification of relationship direction within a Join tile. An option to amend this relationship direction (where appropriate) within the Join tile. E.G A drop-down with 1-2-1,1…
The Magic ETL currently only max out at 400k row for the preview run from your input datasets. This is limiting the test preview in your flow as it only picks (from my understanding) the first 400k ro…
