related to:
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.