Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Create cross tab (flatten rows)

  1. #1
    Join Date
    Aug 2013
    Posts
    6

    Default Create cross tab (flatten rows)

    Looking for help. See below FROM to TO below.

    Tried Row denormaliser, but it requires UniqueKey to be present where there are '***' (in order to use Group field).

    Thanks in advance for your help.


    FROM

    UniqueKey key value
    J3G588 Action Add
    *** JobTitle Consultant
    *** City Dallas
    *** State TX
    J3G5XC CBAction Add
    *** JobTitle Security Officer
    *** City Doral
    *** State FL
    J8B5SS Action Add
    *** JobTitle Sale Rep
    *** City New York
    *** State NY
    *** Zip 10001

    TO

    UniqueKey Action JobTitle City State Zip
    J3G588 Add Consultant Dallas TX null
    J3G5XC Add Security Officer Doral FL null
    J8B5SS Add Sale Rep New York NY 10001

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

    Default

    So why don't you reconstruct UniqueKey?
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Aug 2013
    Posts
    6

    Default

    marabu,

    Thank you. Need time digest, but wow, your example works!

    I am not familiar with the java expression and Group By. But it does the trick.

    You saved me much time. I appreciate your help. Thanks again.

Tags for this Thread

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.