Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Filter and Mapping

  1. #1

    Default Filter and Mapping

    Hi,

    I have few issues

    1) I want to filter the source data with four conditions, How can I achieve this?
    E.g: IF COL1=A THEN OUT1
    ELSE IF COL1= B THEN OUT2
    ELSE IF COL1= C THEN OUT3
    ELSE OUT4 END

    2) I have a i/p column name "Basic",I have to map it it to three different output columns.

    E.g: Basic ---> Net_rev
    Basic ---> TurnoverGross
    Basic ---> Net_value

    How can achieve this?

    Can any body help in this issue. Thanks in advance


    Regards
    Naren.

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

    Default

    1) multiple sequential filter steps, or a switch case step in 3.1
    2) calculator step e.g.

    Regards,
    Sven

  3. #3

    Default

    Hi sven,

    I have tried ,It's working fine.Thank You.

    Regards
    Naren

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.