Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: SplitFields question

  1. #1

    Default SplitFields question

    Hi,
    I am trying to use SplitField to do the following:

    1) Convert a text field in a database which looks like: Division 1, Division 2, Division 3, etc.
    2) Create a one-to-many relationship using a known key in PARENT table to create a LINK table to DIVISION table.


    | PARENT |
    |-------------------|
    | parentID |
    | Name |
    | Address |
    | ..etc.. |
    | divisionList |
    | ..etc.. |
    ---------------------


    | DIVISION |
    |----------------------|
    | divisionID |
    | divisionDesc |
    ------------------------

    | LINK |
    |----------------|
    | parentID |
    | divisonID |
    ------------------

    DIVISION table contains a full text listing of all the possible Division values. It has an auto-generated index of its own. It has already been filled.

    PARENT table contains a text field with a bunch of comma separated DIVISION categories.

    The LINK table would take PARENT.key (parentID) and DIVISION.key (divisionID) and insert a new entry in the LINK table which has only two values: parentID and divisionID. There can be many parentID entries but no duplicate divisionIDs for any one parentID.

    Hopefully that made sense!

    I am stuck on the split fields because I can get the values out, what I cannot figure is how to 'explode' those values into multiple rows one for each value of the SplitField result.

    Do I need to write some JavaScript to process each one?
    Last edited by pdavie; 12-03-2007 at 05:38 AM.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    I'm sure you can use the "Normaliser" step. Take a look at the samples/transformation directory for an example.

    Matt

  3. #3

    Default

    Thanks. Will do.

  4. #4

    Default

    Thanks again, that seemed to do the trick!

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.