Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How join PRPT output and existing xls file

  1. #1
    Join Date
    Sep 2011
    Posts
    12

    Lightbulb How join PRPT output and existing xls file

    I need to run the "Pentaho Reporting Output" step to create a XLS file AND I need to run the "Microsoft Excel Writer" step (using a template) to create a XLS file.


    Until here it's ok... but my problem is... the output XLS file should be a unique file (with the prtp and xls results).


    Any idea?


    * Kettle 4.2.1

    tks
    Gibon

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

    Default

    Serialize access to the XLS file by using different transformations in a job.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Sep 2011
    Posts
    12

    Default

    Hi Marabu,
    thank you for your reply... the transformation with Pentaho Reporting Output component always overwrites the existent xls file...
    I have two transformations as below:
    t1 - with Pentaho Report Output component
    t2 - with Table input and Microsoft Excel Writer components


    The t1 always overwrites the target file, if it exists... then I tried run the t1 and use the target file generated as target for the t2, however the t2 (using the template file doesn't works when the target already exists... and, in my case, we have two or three sheets on the template file).


    Any idea?

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.