Add Formula Rule to Join Tile in ETL

MarkSnodgrass
Portland, Oregon π₯·
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
any users posts that helped you.
**Please mark as accepted the ones who solved your issue.

**Please mark as accepted the ones who solved your issue.
15
Comments
-
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...
1 -
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"1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 466 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 27 γη₯γγ
- 64 Kowaza
- 299 δ»²ιγ«ηΈθ«
- 654 γ²γγγε ±ζ