Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: split some columns

  1. #1

    Default split some columns

    hello forum,

    my table as follows:

    ReferenceOrderID OrderNumber OrderID
    8 AB1000004 52
    8 AB1000004 14
    10 AB1000005 487
    11 AB1000006 86
    11 AB1000006 42
    11 AB1000006 51

    So i would like to split the "ReferenceOrderID" values as follow:

    ReferenceOrderID OrderID_1 OrderID_2 OrderID_3
    8 52 14
    10 487
    11 86 42 51

    Myquestion is if it possible to split. And how can i fix it ?

    many thanks for help
    Last edited by Bernett22; 03-25-2014 at 04:30 PM.

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

    Default

    Hi.
    Have a look at the denormalise step.
    http://wiki.pentaho.com/display/EAI/Row+denormaliser
    -- Mick --

  3. #3

    Default

    Hi,

    many thanks.

    So it works only when i hard coded the key "OrderNumber" into the step field "key value".
    Is it possible to save the values "OrderNumber" into a variable or something like ? So i cant hard coded the 20.000 values into the field manually.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    If you know how many order IDs you're going to get, maybe you could use Flattener.

    Or maybe if you're ambitious, you could look at MetaData Injector?
    Last edited by gutlez; 03-25-2014 at 04:57 PM.

  5. #5

    Default

    good morning,

    thank you for your message.
    When i use the "flattener" step i'm going to lose those "ReferenceOrderID's" which are inside the table for one time.
    For example the "ReferenceOrderID" = 10 is canceld by flattener step

    So is it possible to work with the JavaScript step ? My idea is to create a string field seperated by ";"
    For example:


    ReferenceOrderID OrderID
    8 52;14
    10 487
    11 86;42;51

    How can i fix it ?
    It would be fine to get help

    thanks a lot

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

    Default

    Use a "Group By" step.
    Attached Files Attached Files
    So long, and thanks for all the fish.

  7. #7

    Default

    wow, that's it

    many thanks

    best regards

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.