Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Updating missing values

  1. #1
    Join Date
    Mar 2009

    Default Updating missing values

    Can anyone help, please.
    Which steps can I use to fill in missing values in the excel file which was extracted from the database.
    My problem is this (and I know there must be a simple solution!), I have IDs with missing names in a detailed table and there is another table which has all the names & IDs. I have used the filter to move all the records with missing names to another file but I am stuck at that stage having tried to use database lookup step? To fill in the excel file with missing names. Ideally, I would like to merge the records back so there are no missing names.
    MeriPNG (New to using PDI)

  2. #2
    Join Date
    Mar 2009

    Smile Solved

    Please ignore: Problem solved withou using PDI, just used simple SQL statement to extract values from 2 tables.

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.