Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Step to map several patterns from a table

  1. #1
    Join Date
    Jun 2013
    Posts
    1

    Default Step to map several patterns from a table

    Hi,
    I want to map input values using a table with pattern values. My table is this:

    Row 1: Pattern = Acrobat; Output value = Adobe Acrobat
    Row 2: Pattern = Windows; Output value = Microsoft Windows
    ...

    With this table, I want to get when input = "Acrobat v6", output value = "Adobe Acrobat"
    Another example, If input = "Windows 2008", output value = Microsoft Windows"

    What step can I use? Some suggestion about this?
    Thanks,
    Alberto

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Try the Value Mapper.

    Or Replace in String.

    Mick

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

    Default

    I added two additional test cases to my demo featuring a case-insensitive substring match.
    One shows that the order of the test patterns is important.
    The other shows that I can deal with input rows without a match.
    Attached Files Attached Files
    So long, and thanks for all the fish.

Tags for this Thread

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.