excel output 2 sheets
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.
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.
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...