Magic ETL Join Tile
Apologies if this has been requested in the past. I would like a case insensitivity checkbox on the join tile. In the example below, I have created two datasets. In dataset2, I have a list of words in varying cases: lower, upper, and proper.
If I join the datasets, I get different results based whether the words in dataset1 match the case in dataset2. We only get a match if the joined fields have the exact same case. I know I can use a tile to lower or upper both sides before matching, but that creates extra tiles on an already large ETL. I would like a setting that indicates - join on these fields regardless of the case. So that "Apple" and "apple" match. Or "APPLE" and "apple" match.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **
Comments
-
This would be so very helpful. Thank you for posting this @ArborRose !
If I solved your problem, please select "yes" above
0 -
@ArborRose Something super cool coming to beta that will help with this! Our MagicETL product team has been working on an update to the join tile that will allow for custom expressions as the join condition (think formula-based filter). It's undergoing a small UI update but will be re-entering beta next week.
1 -
@zcameron - that is great news. I am not normally one to champion beta features before release, but a few of these things can't come early enough for me as I stave off the angry villagers at the castle walls wanting to upper case our data.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
Join expressions are fantastic! However, I still agree with @ArborRose. A simple checkbox for case insensitive joins would be very useful even with the new expression features.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive