Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Auto-generated keys

  1. #1
    Join Date
    Aug 2010
    Posts
    6

    Lightbulb Auto-generated keys

    Hello,

    Forgive me if it is a silly question.

    I have a file stream wich I get the follow collums:

    Field1, Field2, Field3, Field4


    Then I'd like to normalize it in the database such this:

    Table_A: IdA (auto), Field1, Field2;
    Table_B: IdB (auto), IdA, Field3, Field4;


    My transfomration steps:
    Text file input > Select values > Table Output -Table_A (with "return autogenerated key" checked)

    And now I'm stuck. How can I get genereted IdA + Field3 and Field4 from inicial stream
    and save them to another output table (Table_B)?

    Thanks,
    Yuri.

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi Yuri,

    I think the idea is to connect another Table Output Step (for table B) to the first one. The output step, like any regular step, passes rows it sees further down the stream (it is not an end point of the transformation). Right click it and select "Show output fields" or "Preview". The fields are there

    Cheers

    Slawo

  3. #3
    Join Date
    Aug 2010
    Posts
    6

    Default

    Many thanks Slawo!
    You saved my day!

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.