Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Row de-normalising question

  1. #1

    Default Row de-normalising question

    Hello Everyone!

    I have a task, and I don’t know how to do it.
    I have a table like this:
    [See attachment: table_1.]

    and I want to make a table like this:
    [See attachment table_2.]


    There are several things:
    • If there are more then 5 elements in the addition, I have to give it a new name, like multiple. (See last row)
    • After the transformation Attr_1, Attr_2 and Attr_3 togethet would be PK. (This means, that all attributes in the original table have the same value for all Attr_1-2-3, except the TO_GROUP attribute. See Attr_N)
    • The grouped data must be in alphabetcial order. (For example: one + two is good, but two + one is not good)
    I’ve tried with Row Denormaliser (http://wiki.pentaho.com/display/EAI/Row+De-normalizer ), but it’s not good for my problem.
    I’ve tried with Row Flatner (http://wiki.pentaho.com/display/EAI/Flattener). It would be ideal, but I don’t know exactly the number of the occuraces of the TO_GROUP attribute.

    Has anyone any idea how can make this?

    Thanks.
    Attached Images Attached Images   
    Last edited by hose; 07-30-2010 at 05:46 AM. Reason: The table is not readable

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

    Default

    Looks like a simple grouping exercise to me:
    - Table Input (with order by clause)
    - Group By
    - Insert/Update

  3. #3

    Default

    It is a CSV input. So I can't use SQL.

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

    Default

    Well, then you can use the Sort step.

  5. #5

    Thumbs up Thanks!

    Thanks Matt!

    That worked.
    First I thoughed, you talking about SQL Group by, but finally I found that step.

    I never used this step, untill now

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.