Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: PDI 5 CE - table input & table output - filter data before save output

  1. #1

    Default PDI 5 CE - table input & table output - filter data before save output

    Hi everyone.

    I want to get data from one database to another. I know how to get input data and how to save output data but before save output I want to filter data from input - I want to insert to table only new records.

    For example:
    Database1 - table invoices - I have column called invoice_nr
    Database2 - table invoices_branch1 -I have column called invoice_nr

    I'm selecting from database1 from tablem invoices all record and want to save those data to database2 to table invoices_branch1 olny those records where database1.invoices.invoice_nr is not in database2.invoices_branch1.invoice_nr.

    What step should I use between Table input and Table output ?

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You can use "Database Lookup" to retrieve the invoice_nr as db2_invoice_nr from database2, then select rows where db2_invoice_nr is null in a Filter Rows step.
    So long, and thanks for all the fish.

  3. #3

    Default

    Can you give me a little more help?


    Which step should I use first?? First Input table then Database Lookup then filter rows and output table??

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You've got it.
    So long, and thanks for all the fish.

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.