There is currently a 100 rows preview window limit when you do the preview run on the ETL. We need to increase this as it can help drastically with further work in the MagicETL.
I am pulling DomoStats data sets for: DataFlow Input DataSets DataFlow Output DataSets First Step - Combining input_output defined as: Select dfin."Dataflow ID" as dfid , dfin."Datasource Input ID" as dsin , dfout."Datasource Output ID" as dsout from "dataflow_input_datasets" as dfin join "dataflow_output_datasets" as…
Currently, when copy and pasting Magic ETL tiles between flows, input tiles are scrubbed and become a plain input tile without a DataSet selected. I understand why you'd want to scrub this if pasted in the same flow, but it should be maintained when pasting in a different flow. This should be relatively easy to implement…
I love the functionality of dynamic unpivot for transforming my data vertically, I would love to see a similar functionality for adding columns
Currently if you use a filter such as <> or != "xyz", this will also filter out any NULL values in the column as well. This is default behaviour for SQL, and I do understand that the reason it's filtering out NULL is because it cannot compare a value to a NULL. So it implicitly excludes NULLs, just as SQL would. The…
I think it would be helpful to be able to lag/lead on multiple columns at once, as long as the partition and ordering are the same. We have multiple ETLs where we have to lag/lead many columns, and having to create a tile for each column doesn't feel very efficient. Thanks!
It would be good to have a "Select All Columns" option for the remove duplicates tile in magic
Instead of having to add each column individually, it would be great if there was a select all columns feature for the remove duplicates step in the ETL.
When working with large enough groupings of tiles, or groupings near the bottom of the canvas in Magic and copy/pasting, there is a tendency for tiles being pasted on the canvas to be squished into the bottom. This can be a pain to untangle and reposition the grouping. It would be helpful if by default or through maybe a…
It'd be great to have a Share Dataflow button which would allow users to share all of the input datasets with a user instead of having to track down all of the multiple dataset inputs and share each of those individually which is quite time consuming.
It looks like you're new here. Sign in or register to get started.