HI,
I am using the lookup_ext function within my dataflow and would like to compare two columns using the upper function. So in effect I'd like to run a upper function on a column within my lookup table and then compare it to a column within the input schema, once again using the upper function.
I understand I can run an upper function on the input schema column, however can't seem to do so on the lookup table column.
Is there any other workaround? I know I can use a SQL query override, but would like to avoid that is possible.
Regards
Azeem