Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Get value from pdi transformation

  1. #1
    Join Date
    Jul 2015

    Default Get value from pdi transformation

    ** Newbie Alert ***
    Apologies if this has been asked before - I did search but could not find anything obviously related.

    I am in process of making a wide range of kettle PDI transformations, many of which are joined together as jobs too.

    I'm now beginning to think about how I will create reports using this data and so trying to learn about the Report Designer and so far so good, but I am now a little stuck with two points:

    1. It's easy to add the transformation as a data source then add a text-field and link that to the field name in the transformation and that 'pulls in' a list of values. In many cases thats just great, but what about if I only want to use a certain value in that list? Is there any way to lock the value in the text-field to a single value in that list of values of that field name?
    2. What if I need to run a whole 'job' to get the transformation to run in order to get the correct value? Would it be better to create a transformation which includes all the pre-work being done earlier in the job?

    As you can tell, I'm a real newbie and will very much appreciate any assistance or links to training/books or videos which might help me figure all this stuff out. The Pentaho suite seems to be be crazy powerful, but not that intuitive to learn!

    Many thanks in advance!

  2. #2
    Join Date
    Aug 2016


    For number 1 I would suggest the easiest thing to do is to put a filter step into the transformation itself and use it in the datasource

    For number 2, I don't think you can use jobs as datasources so it will need to be a transformation. If you can do it all in a single transformation then great, otherwise I'm not sure how you can do it without outputting the result of the job somewhere

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.