Hello! I have 3 excel reader nodes and I wanted to have one output file (excel file) with 3 different sheets for the 3 excel reader but will only show show the information needed based on a common variable. Any suggestion on how I can do this?
Hello,
Have you tried writing the files to the same excel but only writing to one sheet at a time? You can select which sheet to write to for a specific excel in the middle section of the Excel Writer Nodes
1 Like
Yes I have already tried this but I wanted to show limited information only since I have a common variable for the three files so I just wanted to show those information.
Example:
- all 3 files have the 12months period
- File 1 - have the total sales for the month
- File 2 - have the total expenses for the month
- File 3 - average daily sales and expenses
- Excel Output File will only show the 1st quarter sales, expenses and average
Sorry I don’t think I’m understanding, but you would just need to get the data into the format for all 3 files or sheets and then create them.
If final Excel only needs to show the first quarter of sales and not 12 months then you could just filter the data set down to the first quarter before creating the excel.
If you need to create one excel for each quarter, then I would group the data with a group loop and write one excel for each iteration of the loop. Group Loop Start – KNIME Community Hub
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.