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

Answers

  • @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).