Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Logic operators in Formula Step

  1. #1

    Default Logic operators in Formula Step

    Hi,
    I tried using AND, OR operations inside formula step. It shows me an error.

    IF(([A]<[B] AND [C]=[D]) OR ([A]=-999 AND [C]=-1) ;1;0)


    Please help.

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    In the Formula Step, it looks like the OR's and AND's are functions not operators.

    Code:
    IF(OR(AND([A]<[B] ; [C]=[D]) ; AND([A]=-999 ; [C]=-1)) ; 1 ; 0)
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

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.