Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Partial Table Output

  1. #1
    Join Date
    Sep 2008
    Posts
    4

    Default Partial Table Output

    Hi,

    I'm trying to get a Table Output to only input part of the stream into the database. I know i can use Select values but i want to keep some of the other data in that stream to update another table once I get the returned keys from the original update.

    Any suggestions?

    Thanks,
    Ron

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Ron, I feel your pain. Getting a field mapping into that step has been long overdue IMHO.
    Fixing this is top priority for me actually.
    In the mean time, the workaround depends on the situation you're in. For example, you can use 2 transformations, one to insert and one to look up the inserted keys.

  3. #3
    Join Date
    Sep 2008
    Posts
    4

    Default

    Thanks a lot for the quick reply. I was using two steps previously until I saw the "Return auto-generated key" option which i thought would be perfect for what I was doing, but i couldn't keep all the columns in the stream because i got insert errors.

    Basically I'm splitting data up from one table to three tables and I'm having a hard time visualizing how to maintain all the proper relationships between tables.

    Thanks,
    Ron

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    See if you can use the combination lookup step, that one manages the primary key for a set of columns.
    It probably makes it easier to do the split.

  5. #5
    Join Date
    Sep 2008
    Posts
    4

    Default

    That's exactly what i was looking for. Thanks

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.