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


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