Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pass result rows to transformation parameters fail

  1. #1
    Join Date
    Feb 2017
    Posts
    5

    Default Pass result rows to transformation parameters fail

    Example at the following location: https://drive.google.com/drive/folde...mB?usp=sharing

    I want to:
    1) generate some rows in transformation A
    2) for each result row from transformation A, run transformation B, passing the results into the parameters of transformation B

    In the example job, I generate two rows from the first transformation and attempt to pass a value (favorite_food) from the resultant rows into the parameter of the next transformation, and then log the value to the console.
    Although the second transformation is executed twice as expected, the value logged to the console is always empty. Am I failing to appropriately reference the "Stream Column Name"? What could be the issue?

    === Logging ===
    ...
    2018/11/14 16:29:51 - Get Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2018/11/14 16:29:51 - Write to log.0 -
    2018/11/14 16:29:51 - Write to log.0 - ------------> Linenr 1------------------------------
    2018/11/14 16:29:51 - Write to log.0 - favorite_food =
    2018/11/14 16:29:51 - Write to log.0 -
    2018/11/14 16:29:51 - Write to log.0 - ====================
    2018/11/14 16:29:51 - Write to log.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2018/11/14 16:29:51 - logPreviousResults - Using run configuration [Pentaho local]
    2018/11/14 16:29:51 - logPreviousResults - Using legacy execution engine
    2018/11/14 16:29:51 - logPreviousResults - Dispatching started for transformation [logPreviousResults]
    2018/11/14 16:29:51 - Get Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2018/11/14 16:29:51 - Write to log.0 -
    2018/11/14 16:29:51 - Write to log.0 - ------------> Linenr 1------------------------------
    2018/11/14 16:29:51 - Write to log.0 - favorite_food =
    2018/11/14 16:29:51 - Write to log.0 -
    2018/11/14 16:29:51 - Write to log.0 - ====================
    2018/11/14 16:29:51 - Write to log.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2018/11/14 16:29:51 - example_job - Starting entry [Success]
    ...

  2. #2
    Join Date
    Apr 2008
    Posts
    4,639

    Default

    Yeah, I don't know...

    I downloaded your sample, ran it with Debug set to Row Level and it worked right away.

  3. #3
    Join Date
    Nov 2009
    Posts
    672

    Default

    I guess you are using version 8.1. In that version passing parameters to another transformation is not working as expected. See f.e. https://jira.pentaho.com/browse/PDI-17343 . This issue is fixed in version 8.2

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 - 2017 Pentaho Corporation. All Rights Reserved.