When I use a value lookup I want to adjust the content of the output.

My problem is that I need to convert a number value in my Value Lookup table  to a varchar2 in my original table (Oracle)

How do I do that?

Step-by-step guide


  1. Select the table and column
  2. Add the function Value Lookup
  3. The Function Editor opens.
  4. Specify the Input Column and Lookup column to find the data.
  5. Specify the Original column as target for the new data.
    So far nothing new.


  6. Then: Specify an expression/function for the lookup column. In this example: TO_CHAR(CUSTOMER_ID_PNEW)