Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Stumped on transformation

  1. #1

    Default Stumped on transformation

    I've been doing this in the SQL for the source but would really rather push the logic to the Kettle transformation ...

    Source:
    Field / Value
    MyKey / 1
    MyString / 'AAA<Val1>A<Val1><Val2>B<Val2><Val3>C<Val3>'

    Target:
    Field / Value
    MyKey / 1
    MyString / 'AAA'
    Val1 / 'A'
    Val2 / 'B'
    Val3 / 'C'

    Any suggestions on the most straightforward way to do this in a transformation?

    Thanks!

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    JavaScript step and E4X... it will not be fast and currently you need to tweak some things (replace js.jar and add e4x libraries in PDI) until http://jira.pentaho.org/browse/PDI-57 is implemented.

    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.