Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: extended conditions

  1. #1
    Join Date
    Mar 2010
    Posts
    25

    Exclamation extended conditions

    Which is the best step to handle a condition like this ?

    Acquisition Code ≠ 99999 and,
    Office Code ≠ 9999 and,
    Office Code ≠067698 and,
    Department Code ≠ 00123 and,
    Department Code ≠ 04616 and,
    Department Code ≠ 06572 and,
    Company Code = 00900 or,
    Company Code = 00567530 or,
    Company Code = 00176871 or,
    Company Code = 007780 or,
    Company Code = qwerqw or,
    Company Code = asdfadsf or,
    Acquisition Code ≠ 99999 and,
    Office Code ≠ 0398 and,
    Department Code ≠ 00347 and,
    Department Code ≠ 026616 and,
    Department Code ≠ 0623470 and,
    Department Code ≠ 0653472 and,
    Company Code = 0034500 or,
    Company Code = 0034320 or,
    Company Code = 006787601 or,
    Company Code = 0089810 or,
    Company Code = qwerqwe or,
    Company Code = asdfasdf

  2. #2
    Join Date
    Mar 2010
    Posts
    25

    Default

    I reckon, "formula" might help. But are there good samples ? Any KTR's with this embedded might help tremendously.

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

    Default

    Change ≠ to <>
    Put double quotes around the codes (values)
    Get rid of the commas (,)
    Change and to &&
    Change or to ||

    put it in the Java Filter class or the JavaScript step.

Tags for this Thread

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.