Difference calculator

[Nick9403]

I am completely new to Knime and if my question here is silly, I apologize for it.

There are 2 dummy input files. One is previous week’s extract and another one is the latest week’s extract. Both the input files contain sales data.

The output file should contain 3 sheets;

1. Data from current week’s extract
2. Data from previous week’s extract
3. Difference between the sales number

But the workflow should be versatile enough to capture the change in column name, if any, and still generate the output.

I have attached the dummy input and output files for your reference.
Input 1-20.10.2023.xlsx (8.5 KB)
Input 1-20.10.2023.xlsx (8.5 KB)
Sales.xlsx (10.9 KB)

[Daniel_Weikert]

Hi
you can append several sheets when you write the data to an excel file using excel writer node (you can add additional input ports by right click)

For the difference I would suggest unpivot the sales columns in both sheets do the subtraction using (math formula node) and pivot the data back (upivoting and pivot nodes are available)
br

[Nick9403]

thanks for this solution. Will try.