Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: excel output 2 sheets

  1. #1
    Join Date
    Aug 2008
    Posts
    3

    Default excel output 2 sheets

    Hi,

    We are using spoon, and we would like to have a excel output with 2 sheets.

    We have a filter:

    - we want to send true data to a excel file (for example 'proof') and a sheet (sheet1)
    - we want to send false data to the same excel (proof) but in another sheet (sheet2).

    Is it possible to make with spoon?

    We had made some test, but spoon create one excel file with only sheet when should have two diferents sheets, i.e., overwrite the sheet.

    Could you help us?

    Thanks so much.

  2. #2

    Default

    Hi,

    You can use the append option.

    Create the first file like you do and use another Excel Output with "Append" option checked.
    PDI will append you excel File by adding the second sheet.

    Samatar
    Samatar

  3. #3
    Join Date
    Aug 2008
    Posts
    3

    Default

    Could you explain it better?

    We have a lot of doubt:

    Where do we have to use append? both? just one? what?

    Do we have to create a template before? Where do we use it? In both excel output? Or only the first one?

    Maybe, the problem is the filter, because both files are created in the same time... maybe...

    Thanks again.

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.