Add Formula Rule to Join Tile in ETL

MarkSnodgrass
MarkSnodgrass Coach
edited February 2024 in Magic ETL Ideas

It has been extremely useful in Magic ETL 2.0 to have the Add Formula Rule available in certain tiles such as the Filter tile or Group By tile. I would like to see it be available in the Join tile as well. This would make it operate more like a SQL join. For example, if I need to use a BETWEEN statement for my join key, I can't do this immediately in the Join tile, but have to add several additional steps before and after in order to get to the final result.

**Check out my Domo Tips & Tricks Videos

**Make sure to <3 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.
Tagged:
15
15 votes

Implemented · Last Updated

Good news - this is in beta now! Look for more detail at Domopalooza.

Comments

  • Ritwik
    Ritwik Contributor

    Great idea, very much needed. I have some dataflows I have yet to move to Magic 2.0 simply because of this. Will get to it soon enough...

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    oh my goodness yes please.

    the lack of JOIN on a BETWEEN forces users to do nasty cartesian product joins OR forces them to use other ETL tools.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • AndreaHenderson
    AndreaHenderson Domo Product Manager

    Good news - this is in beta now! Look for more detail at Domopalooza.

    Domo Product Manager for Data Transformation (MagicETL)

Categories