Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Issue with Step Mapping (sub-transformation)

  1. #1
    Join Date
    Jan 2012
    Posts
    4

    Default Issue with Step Mapping (sub-transformation)

    Hi,

    I've tried to do an example that I found in the book "Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration" p.175

    Goal is to conform data coming from different sources.

    In this example, I try to conform values from the "Gender" column coming from different sources.
    E.G.:
    Source file Web
    Genre = male, female
    Source file Sales
    Genre = M, F

    Output values must be Male, Female.


    I'm using an Excel file as reference table which contains:
    • Values from different sources
    • Source type (Web, Sales)
    • Desired output values (Male, Female)


    Therefore, I'm using a sub transformation (Step mapping (sub-transformation)) in which I set a variable ${src_system}

    In the first process, variable will have the value Web.
    In the second process, variable will have the value Sales.

    Issue is that PDI doesn't recognize this variable in the sub transformation.

    In the sub transformation, I'm using this variable as a filter.
    When I don't use this variable, It's working perfectly.

    It seems that my variable is not well initialized. (but following the book it should be working --> or I've miss something

    Thanks for your help.

    In the attachment files, I'm only working with data grid (not with tables), so it would be easy to test if you want
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2013
    Posts
    235

    Default

    ...sub-transformation should have defined this parameters you want to pass down.

    In this particular case - test2.ktr have to define 'src_system_param'.
    This is well know feature (), hope will be fixed with http://jira.pentaho.com/browse/PDI-3064 when it will be backported if future (or will be released with new version).

    I don't take a close look to your sub-transformation, so hope this will help.

  3. #3
    Join Date
    Jan 2012
    Posts
    4

    Default

    Hi Dzmitry,

    Thanks for you help,


    If I understand well.
    (I'm french speaker, so I try to do my best in English )

    This is a bug.

    Best way to simulate this functionality will be using a job and passing variable values to it?
    Last edited by L0007; 06-11-2014 at 04:26 AM.

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.