Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Denormalising Multiple Values in Field

  1. #1
    Join Date
    Oct 2007
    Posts
    5

    Default Denormalising Multiple Values in Field

    I have a table with a freeform text column containing a comma delimited list of values. I would like to transform this so that I end up with a row in the fact table for each delimited value (all other column values being equal).

    This is what I would call denormalising, but this is not what the Denormaliser step does, and I can't find any other step that will do what I need.

    I've thought of parsing the delimited string into an array and then iterating through the values, but Spoon won't allow looping so I'm not sure how I can make use of this.

    Thanks for any help or ideas.

    PChandler

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

    Default

    Split rows plugin for 2.5 : http://wiki.pentaho.org/display/EAI/...ation+Plug-Ins (probabaly still needs a migration to 3.0).

    And on 3.0 you could also do something like following in javascript http://wiki.pentaho.org/display/EAI/...2.5.x+to+3.0.0 under "Adding rows dynamically" (which would also work on 2.5 with some rewriting )

    Regards,
    Sven

  3. #3
    Join Date
    Oct 2007
    Posts
    5

    Default

    Thanks, Sven. The plug-in for 2.5 looks like an exact fit for the requirement.

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.