Magic ETL - Lower Case to Upper Case Join
I've got some extral data coming in via FTP that contains a key field that sometimes has lower case charcters. Attemping a join in Magic ETL and some appear to be failing based on case difference (lower case in one and upper case in the other).
How best to fix?
- Is there a way to format a field as UPPER CASE in Magic ETL?
- Is there a way to do a join in Magic ETL that's not case sensitive?
- Other ideas?
Best Answer
-
It might not be exactly what you want to do but MySQL DataFlows support the UPPER function you could perform your ETL work in MySQL instead of Magic ETL.
Alternatively you have the MySQL Dataflow just do the upper conversion and then use that MySQL dataflow as your input into your current Magic ETL.
You'd think they'd have a LOWER or UPPER option in the string operations tile. I've posted a new idea for it: https://dojo.domo.com/t5/Ideas-Exchange/Add-UPPER-and-LOWER-other-formatting-functions-as-options-in-the/idi-p/47951
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
It might not be exactly what you want to do but MySQL DataFlows support the UPPER function you could perform your ETL work in MySQL instead of Magic ETL.
Alternatively you have the MySQL Dataflow just do the upper conversion and then use that MySQL dataflow as your input into your current Magic ETL.
You'd think they'd have a LOWER or UPPER option in the string operations tile. I've posted a new idea for it: https://dojo.domo.com/t5/Ideas-Exchange/Add-UPPER-and-LOWER-other-formatting-functions-as-options-in-the/idi-p/47951
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@GrantSmith thanks for the reply. I'm really trying to do this in Magic ETL so I don't have to add another layer (if possible).
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive