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?

    Hi,

    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
    Posts
    4,882

    Default

    Start that the getting started part at http://wiki.pentaho.com/display/EAI/...+Documentation

    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.

    Regards,
    Sven

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.