Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: converting data in Rows to columns while uploading in database

  1. #1

    Default converting data in Rows to columns while uploading in database

    can anyone help in converting data in rows to columns while uploading data in database using SQL server..........

    for eg.........

    In Spoon,
    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.

    Now , if we want this rows data to be uploaded in the Database in form of columns , then How to do it????????/


    manish 702 34 567 4556 678 (in excel file)
    to
    manish
    702
    34
    567 (in Sql Query browser)
    4556
    678

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Change all of the metadata to string (using select values e.g.) and then use Row Normalizer.

    Regards,
    Sven

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.