Magic ETL Join Tile Alterations Field Search

AustinHarrison

We have really appreciated all the quality-of-life updates to Magic ETL over the past few months! I have a few ideas to improve a pain point we frequently encounter when building ETL's. Some of our standard schema is verbose and requires field name prefixes when ingesting from certain systems. When we attempt to alter certain columns in a join (when a preceding tile to make the change is not optimal or functional) we have issues finding the correct column. I have included a screenshot to give an idea of what the UI looks like for one of our commonly used datasets.

Our idea is three fold:

1. Let us control the width of the popup sub-menu to see more of field name string to ensure we select the correct field.
2. Add a search function, similar to the join conditions section, to make finding the desired field easier.
3. If we select a field, and it turns out to be the wrong one, let us change that field "in place" without having to delete the alteration and add a new one.

Any one of those 3 additions would make a massive impact on our Magic ETL experience.

Thanks!

Austin - HS1

Join Alteration Select No Search.PNG