Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to search modified values?

  1. #1

    Default How to search modified values?


    I am a newbie, so apologize if this is too simple or been asked before.

    I have a requirement where I have a product SKU as a DB column and I have 1 coming in from a spreadsheet. I need to compare the 2 with certain formatting characters removed e.g. - , : etc and only compare alpha numeric characters in both the fields and perform insert/update based on whether it matches or not.

    I know I have to use Stream Lookup and Insert/Update step and Modified Javascript step - but I cant figure out how to put those together to fulfill the requirement.

    How would I do that in DI (Kettle)?

  2. #2
    Join Date
    May 2006


    Start that the getting started part at

    For the rest you just connect all steps with hops (in the right order).

    The comparing with the table in the field stripped of special characters will be challenging unless you e.g. also store the value as stripped value in an extra column.


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.