Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use lower case function in Value field of an ODI variable

3673816Oct 4 2018 — edited Oct 4 2018

Hello.

I have a simple global variable in ODI. Let's call it #GLOBAL.VAR1.

I have two other global variables - #GLOBAL.VAR2 and #GLOBAL.VAR3, whose values I need to convert to lower case, then concatenate (with a dot in between) and assign the result to #GLOBAL.VAR1.

If I make my #GLOBAL.VAR1 variable type as "Set Variable", then is there a way to use some kind of TO_LOWER function in the "Value" field, so that something like this would work:

to_lower(#GLOBAL.VAR2).to_lower(#GLOBAL.VAR3)

I know I can get away with a "Refresh" variable type and just call a SQL and use its LOWER and UPPER functions, but I was hoping to do it "natively" within the ODI's "Value" field using some kind of scripting functions.

Would that work and if so, how?

Thanks

Boris

Added on Oct 4 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

144 views