Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: how can we take input for next steps from table output steps?

  1. #1
    Join Date
    Mar 2007
    Posts
    158

    Default how can we take input for next steps from table output steps?

    Hi folks,


    Is there any way so that I can take the input for the next steps from the table output in the same transformation?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Table output without setting options will pass the input row, so yes. You can also switch on "return auto generated key" and that that one will also be added to the row.

    Regards,
    Sven

  3. #3
    Join Date
    Mar 2007
    Posts
    158

    Default

    I m taking output to a database table on my remote server and then I want to use the same table's data for next steps!
    So I want to take the input from the output table step and then I want to process a query on this table in the same step!

    Here I m attaching my transformation diagram!

    In essence I m looking for the way so that I can use the same data which has been stored in a table recently using a few steps in the transformation, and want to forward this table data to the next step where I want to process a query on this table data.
    Attached Images Attached Images  

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Only the input row + surrogate key... but in table output (in 2.5) for the moment it would be the same as the full row (maybe without some defaults or trigger based stuff).

    Use different transformations.

    Regards,
    Sven

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.