Skip to main content
Skip table of contents

Can I adjust the value of the Lookup Column in my ValueLookup?

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)


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.