Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Using lookup databa

  1. #1

    Unhappy Using lookup databa

    I'm trying to insert data into a table, extracting data from one table comparing one field from another field using the lookup DATABASE type. I used the type SELECT VALUES to exclude that one with null values, but it still being used by kettle to insert into the output table. Just one field has the data which is of my interest, but seems to me just with the value null one being accessed.

    Please someone could guive some tips how to utilize the select values properly?

    Error inserting row into table [dim_service] with values: [White Label], [TIM], [Assinatura], [Acotel MMS], [100], [null]

  2. #2
    Join Date
    Nov 2013


    I am not sure how you are attempting to use "Select values" to exclude nulls, but my first instinct would be to use a "Filter rows" step. You can check specifically if a field is null and then redirect only the rows that pass to the next step. The "Filter rows" dialog is a bit unclear, but the "=" in the default comparison is a drop-down which you can use to select "IS NULL" or "IS NOT NULL." Make sure to direct the rows you don't want to a Dummy step so you can just end processing there.

Tags for this Thread

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.