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?