JOIN on LIKE and BETWEEN in Magic 2.0

Options
jaeW_at_Onyx
jaeW_at_Onyx Coach
edited December 2023 in Magic ETL Ideas

related to:

https://dojo.domo.com/main/discussion/52317/join-with-between-clause-in-magic-etl

https://dojo.domo.com/main/discussion/comment/28356#Comment_28356


It would be ideal to be able to perform a JOIN on a LIKE, BETWEEN, LESS THAN (or equal to) and GREATER THAN (or equal to) in Magic 2.0.


Currently, users have to either do a full cartesian product (see threads above) or shift their pipeline over to SQL dataflows to get similar results.

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"
18
18 votes

Implemented · Last Updated

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

Comments

  • 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