Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Fitler Rows

  1. #1

    Arrow Fitler Rows

    Hi All
    I have question. I have two tables one is master and other is slave. Suppose both have 1 column ABC, Now I want to insert only those rows from master which are not present in slave table. e.g if Master has following rows.

    ABC
    row 1
    row 2

    and slave has following

    ABC
    row 1

    then row2 will be inserted in the slave table. how can i do this using ketlle?

    Thanks
    Shuja

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    Read both tables, and join the streams with a Merge Rows (diff) step to find out the differences before inserting.

    http://wiki.pentaho.com/display/EAI/Merge+rows

  3. #3

    Default

    yes it works
    Thanks Maria.

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.