Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How To split a table in multipe excel files ?

  1. #1

    Question How To split a table in multipe excel files ?

    Hi all, I want to split a mysql table into mutltiples excel files with the same name but in multiple directory.
    This in order to insert them as linked excel objetct in a word file.
    first I create the variable path of the filename with a table columns extract .
    As the csv file fonction outputname can be a field of the stream I use it to append stream lines into the constructed file.
    But my goal was to obtain excel files not csv.
    But excel output fonction don't take the filename as an input field .
    Soi I get more than 200 csv files in 200 differents path , how to have them in xls ?

    Thanks.

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

    Default

    If you make your transformation part of a job, you can add another transformation to gather all CSV filenames and calculate the XLS filename.
    A third transformation can be made to loop over the CSV filenames, while receiving the XLS filename as a parameter.
    So long, and thanks for all the fish.

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.