Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: update step with null values in lookup columns

  1. #1

    Default update step with null values in lookup columns

    I have a situation where i have to update a table based on a lookup which includes a column which has null values in it. What i am doing right now is that i am typecasting the source columns with a nvl function to produce a 0 if the value is null, but in the update step i cant do a nvl on the target table columns. This means that the lookup fails.

    I tried to circumvent this problem by using a sql step but for a 100,000 row size this isnt feasible.

    Any ideas on how to circumvent this problem?

  2. #2
    Join Date
    Nov 2008
    Posts
    1

    Default similar prob

    have a table with about 12 columns. need to update the value in each column with data from several lookup tables. what do i do??

  3. #3
    Join Date
    May 2006
    Posts
    4,882

    Default

    Pick a random thread ... call it similar... and hijack it Try again

    1 hint: you need to get all of your lookup data in the input row before you hit the insert/update step.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.