Add Formula Rule to Join Tile in ETL

MarkSnodgrass
MarkSnodgrass Portland, Oregon πŸ₯·
edited May 2 in Ideas Exchange

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.




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

Submitted Β· Last Updated

Comments

  • Ritwik
    Ritwik Atlanta 🟑

    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 Budapest / Portland, OR 🟀

    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"