Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Formula Step - Datatype

  1. #1

    Default Formula Step - Datatype

    Hi,
    I tried giving the below formula in the 'Formula Step' and defined the datatype as 'Integer'.

    IF([SID]>=36;-1;IF(AND([SID]>=24;[SID]<36);0;1))


    But while running the transformation, it throws an error saying, Give Number datatype to the column in the formula step. The output of the calculation is going to be an integer (either 1/0). Even then it is showing an error. Please help. I need it as an integer.


  2. #2
    Join Date
    Feb 2008
    Posts
    107

    Default

    You can change the datatype from Number to Integer using a Value Mapper step (in the Meta-data tab) following the Formula step.

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.