Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Choice between Formula and Javascript step ?

  1. #1

    Default Choice between Formula and Javascript step ?

    What would be the best option for doing string operations like concateneation,Replace,Substring etc.. as well as Logical operations like IF then ELSE.
    Should I prefer Javascript over the formula Step,which will perform better in long runing transformations ?

    -Thanks and Regards

  2. #2
    Join Date
    Nov 1999


    The "User Defined Java Expression" or "User Defined Java Class" steps perform best.
    Then Formula, then JavaScript. No idea about the Ruby step performance yet.

  3. #3
    Join Date
    Nov 2008


    For the IF THEN ELSE, use the Filter rows step or the Switch / Case step. I have not tried the Java Filter step but it looks promising. In general, use JavaScript as a last resort because it performs the poorest.
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  4. #4


    Thank you for all your Inputs, I will keep you posted on my findings for the same.

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.