Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Database Lookup and missing Fields

  1. #1
    Join Date
    Dec 2015
    Posts
    1

    Default Database Lookup and missing Fields

    I am using the Database Lookup step to get the value of a lookup item. However, not all rows in the data stream will have a value to be looked up. I have setup the Database Lookup to use a default value. In the subsequent step, I'm using the Select Values step to map the new field created in the previous step to another field that is needed later in the pipeline.

    However, this is failing at times because it appears that the Database Lookup step is not adding the new field. The Select Values step fails because it cannot find the missing field.

    How do I handle this? I cannot find anything to show me how to update a field when its missing, just to handle setting the values. Is there a better way to handle what I'm trying to do?

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    However, this is failing at times because it appears that the Database Lookup step is not adding the new field.
    Very odd.
    Are you sure that your transformation is not failing because the Input file is missing a field?
    -- Mick --

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.