Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Recursive "Stream Value Lookup" - how to retrieve multiple rows back or array values?

  1. #1

    Question Recursive "Stream Value Lookup" - how to retrieve multiple rows back or array values?

    All -

    Quick question .. I have a stream lookup step which there could be multiple rows that match Lookup field. Is there a way to match all rows and retrieve an array of values for the field?

    Thank you in advance.

    KP

  2. #2
    Join Date
    Feb 2016
    Posts
    22

    Default

    If I'm understanding correctly, you can use the Merge Join component instead of the Stream lookup (flows need to be ordered by the join key first).

    Once you have the result, you can use the group by component to include them in a single array

    If you have to process a massive amount of rows, please be aware that it will consume a higher memory than other processes

    Hope this helps

Tags for this Thread

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.