Skip to Content
0
Former Member
Feb 13, 2009 at 03:19 PM

lookup_ext - Using functions

42 Views

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