Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: store data in the same excel excel I'm using in the ETL

  1. #1

    Default store data in the same excel excel I'm using in the ETL

    Hello,

    I am working with PDI and I have a doubt.
    I have an ETL that extracts data from an excel file, then compare it to others,make processes and have new data.
    What I need is to aggregate the new data in the same excel file which opened at the beginning of the ETL.

    I tried pointing the options "Append" and "dont create file to start", but what does is replace the old data with new data.

    How can I do this???


    Thank you very much that I can help me.

  2. #2
    Join Date
    Jun 2011
    Posts
    102

    Default

    Hi,
    I suggest you to use the excel writer step to do this kind of operation: if you're using PDI from 4.2.0 on you can find it in the sperimental folder, on the otherside you can download it from http://type-exit.org/adventures-with...gin/#downloads

    In the Content tab you must check "Start writing at the end of the sheet".
    HTH,
    Andrea

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.