Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Looping Transformation Container

  1. #1
    Join Date
    Jun 2009
    Posts
    17

    Default Looping Transformation Container

    Is there a [Repeat Loop] container, which Loops a Condition, until that condition while true?

    This Container would then have transformation steps within it.

    Examples include:

    Loop an in-memory recordset (generally inserted via a sql select order by)
    Loop a set of constants (Input as constants in UI transform step)
    Loop through all files in a folder (usually used to copy to a staging folder)
    Loop While <expression> (general purpose to group transformation steps)

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

    Default

    There's no "loop container", but all can be achieved in other ways.

    Regards,
    Sven

  3. #3
    Join Date
    Jun 2009
    Posts
    17

    Default

    Sorry - not seeing any way using the tool that "all can be acheived in other ways".
    Repeat Loop containers are fundamental to an ETL tool. Kind of like on a programming language - if they do not exist - no good to achieve the same functionality.

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

    Default

    David, perhaps you can look in the samples/jobs folder?

    "shell for every row" or "process all tables" are typical examples of looping over a set of rows.

  5. #5
    Join Date
    Jun 2009
    Posts
    17

    Default

    Matt,
    Thanks! - I will take a look at those.
    Dave

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.