Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Update an existing Excel XLSX (Output step - update an Existing Multi-Work XLSX)

  1. #1

    Question Update an existing Excel XLSX (Output step - update an Existing Multi-Work XLSX)

    More I use PDI ... I love it!!! So now again a question for you gurus...

    I use the MS Excel step in my transforms (grab data from multiple worksheets), but during my transform I do "lookups" and get additional information from another source. I would like to update the original MS Excel (specific Column in a specific Worksheet). I know I can not update the same file in a transformation, so I am looking for some creative solutions to:

    1. Update a Column an existing XLSX worksheet?
    2. If the XLSX is being used as the Input Step, what is the best way to update the SAME file (at the Job level or a new transformation?)

    Thanks in advance!

    KP

  2. #2

    Default

    Ok disregard this thread .. I was not using the MS Excel Writer - just tested as designed.

    KP

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.