Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Quick step question

  1. #1

    Question Quick step question

    Hello! I have an issue that I've been searching the forums and web for without success and I'm hoping you guys can help. I'm working on a transformation and I'm trying to update an integer value. I know that there is a way to replace/change a string value in stream using the "Replace in string" step, is there anything similar for integers (or any non-string)? Right now I only want to increment one of my fields after it fails a certain condition - I have the other logic set up, but all I can find for this is the Calculator step which creates a new field.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Adding to a field can easily be done using a User Defined Java Expression.
    Attached Images Attached Images  
    So long, and thanks for all the fish.

  3. #3

    Default

    Thank you!

  4. #4

    Default

    P.S. Update for anyone who finds this thread while searching: I found a step for what I was trying to do manually called the "Add value fields changing sequence":
    http://wiki.pentaho.com/display/EAI/...nging+sequence

    This is much more straightforward than trying to create a loop and doing the Java step for this particular case

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.