Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: IF-clause in PDI

  1. #1
    Join Date
    Mar 2016
    Posts
    18

    Default IF-clause in PDI

    Hello,

    i want to implement some kind of if-clause in PDI.

    I got three parameters in the transformation which are all strings and now i want to check whether the combined length of all three parameters is smaller than 20. At this condition the program should decide how it operates next (which step it takes next, e.g. creates a new table or on the other hand adds a new column - that doesn't matter for now).

    So is there any possibility to design such an "if-clause" in PDI?

    Best regards

    Thomas

  2. #2
    Join Date
    Aug 2011
    Posts
    360

    Default

    For transformations:
    Filter step: implement if clause for basic conditions
    Java filter step: if clause for everything you want conditions
    Switch/case step: implement switch (field) case value1 .... case value2 conditions. Split the stream into multiple stream based on fixed set of values of one field.

    Jobs:
    Simple conditions step or javascript 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.