Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Appending Data in Excel

  1. #1

    Default Appending Data in Excel

    I am using pentaho to collect and proccess data from my home automation system.

    Ultimately I want to schedule it to run every 15 minutes and add the data as another row in an excel table so I can analyse it.

    However I am struggling to get excel to append the data. Every time I run the transform it replaces the previous data with the current data. I have tried both the excel output and the excel writer, the configurations of which are shown below.

    Is there a particular configuration required to get this to work?
    Attached Images Attached Images      

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi.
    I would use a text file to do the same thing.
    It's smaller and more reliable when it comes to data formatting.
    You can always read it with multiple programs, while Excel can be more problematic.

    But in Excel, if you have "Append" checked, then I would remove the "Header" option or you will probably end up with a header line in the middle of your file.

    Next time instead of showing screenshot, attach your transformation.
    -- Mick --

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.