Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Not Able to Transpose Data

  1. #1

    Lightbulb Not Able to Transpose Data

    Hi

    I am a newbie to Pentaho

    Want to transpose a excel data

    Input Data

    A1 B1 B2 B3 -> Header Row
    a1 b1 b2 b3
    a2 c1 c2 c3


    to output data

    A1 a1 a2 -> Header Row
    B1 b1 c1
    B2 b2 c2
    B3 b3 c3

    I am not able to find how to approach this problem

    The problem is compounded as no of rows and columns are not fixed.

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    You will probably have to write a User-defined Java Class to perform a transpose. Obviously, you will have to accumulate all the input data rows before transposing and writing the output rows. Look here for an example of a matrix operation UDJC step I wrote a while back that may be of some help.

    http://forums.pentaho.com/showthread...rix-operations
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

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.