Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Setting Flag condition for specific dates

  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Default Setting Flag condition for specific dates

    I would like to set a Flag '1' for if year =2006 and '2' for all other years during transformation.
    Any help/example is greatly appreciated.
    Regards

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

    Default

    Easiest would be with javascript, but other solutions work as well... stream lookup with a 1 for 2006 and using 2 as default value e.g.

    Regards,
    Sven

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    User defined Java Expression:

    Code:
    year==2006 ? 1 : 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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.