Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Table Output Idea for Improvement

  1. #1
    Join Date
    Mar 2006
    Posts
    26

    Default Table Output Idea for Improvement

    Hello, I wanted to request for an improvement on the Table Output step.

    Proposal:
    I believe that the Table Output step should use a list of fields that will be used in the step... like the "Select" step, maybe in another tab or something.

    Reason:
    I have seen/needed in many transformations the need to insert data into a table, and then retrieve the Primary Key assigned to it... and later use that information for following steps. Since the, table output uses all fields, I cant have there data requiered for the next steps, pushing me to use splits of data, select fields, and then Joins/lookups based on many fields in other to rejoin the data.

    I believe this will cause no harm to the Kettle application and will make it more flexible.

    Ohhh one more thing.. in order to maintain back compatibility with previews transformations, may you can put it in another tab with a check box that says "Specify Fields"... that way for prev. transf will continue to use all since the check box will be out.

    Hope this helps.. thanks.

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

    Default

    We already have a step for that, it's called "Combination Lookup/Update".

    HTH,

    Matt

  3. #3
    Join Date
    Mar 2006
    Posts
    26

    Default

    Matt,

    I don't see how to use the Combination lookup/Update for what I as doing.

    Let me explain with a CASE of USE just in case I miss explained

    TABLE INPUT STEP: get 10 fields from a table(s)
    TABLE OUTPUT (OR SIMILAR): insert 5 files from prev select and retrieve the primary Id assigned.
    TABLE OUTPUT2: insert the other 5 filelds from INPUT + primary key prom previews step.

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

    Default

    That's exactly what that step does. :-)

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

    Default

    A similar request is open as http://jira.pentaho.org/browse/PDI-16 ... it's already open since 2.3.1

    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.