Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How to perform an UNION ALL in kettle?

  1. #1
    Join Date
    Jul 2007
    Posts
    247

    Default How to perform an UNION ALL in kettle?

    Hi everybody,

    I was wondering, how one could perform an UNION ALL statement via a step in kettle. I know that there's the Merge Rows step, but that will only be good for a UNION but not UNION ALL - or am I missing here something?

    Thx in advance,
    Ben

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

    Default

    Just use a dummy step with multiple inputs and 1 output.

    Regards,
    Sven

  3. #3
    Join Date
    Jun 2007
    Posts
    103

    Default

    Sven - I just wanted to thank you. Three years later your answer helped me out.

    - Russell

  4. #4

    Default

    Hi,

    dummy step performs a Union all but others steps also :-)

    Samatar
    Samatar

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.