Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Turn Column Into Row

  1. #1
    Join Date
    Jul 2013
    Posts
    28

    Default Turn Column Into Row

    I have a column of data like this:

    cat

    1

    8166DT745

    DOE,JOHN

    19480613

    US

    20140430

    ND

    Which I would like to turn into a row that looks like this:

    cat 1 8166DT745 DOE,JOHN 19480613 US 20140430 ND

    Is there a widget that does this without have to write a lot of Javascript? Just looking for something easy.

  2. #2
    Join Date
    Nov 2008
    Posts
    271

    Default

    Use either Row flattener or Row denormalizer. They are under transformation folder in Spoon design tab)
    Andrea Torre
    twitter: @andtorg

    join the community on ##pentaho - a freenode irc channel

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

    Default

    Row Flattener it is, provided there are no repeating fields.
    So long, and thanks for all the fish.

  4. #4
    Join Date
    Apr 2014
    Posts
    2

    Default

    what database you store your data ? I would like to use 'decode' to finish the work.

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.