Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Excel data to table ouput

  1. #1

    Question Excel data to table ouput

    Hi

    I am stuck in one problem.
    Please see the attached excel file.
    I want to get data from it and want to store in the table with columns :ID,WeekNo,Target, value1,value2,value3.

    If we take the input as Excel input and retrieve data from excel file,the output is in the form of rows as given in excel file.


    How to convert this data in Rows to columns while uploading in database?

    Thanks in advance for helping me out!
    Attached Files Attached Files

  2. #2

    Default

    http://forums.pentaho.org/showthread.php?t=60939
    Has he not already answered your question? or do you need to ask it in as many different ways possible?

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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.