Hi. I have a MoM data where I need to compute for the difference of current month to previous month. Ie, For Jan2022 it should be Jan 2022-Dec 2021 values. Note that my months are dynamic - An output can have Dec 2021, Jan 2022 months today, then for next month it will have Dec 2021, Jan 2022 and Feb 2022… and so on.
Would the 3 months be sorted (as in oldest month left, newest right)?
Would the columns always be in the same position (B, D, E)?
FYI, you can access columns by position, regardless of their names, via the Column Expressions node, using the column() function. column(0) would be for the first column column(1) would be for the second column column(2) would be for the third column
etc
Assuming that the answers are “Yes” for all of my questions above, then you do what you need in 2 expressions: column(3) - column(1)
and column(5) - column(3)
In the future, please provide sample data that we can import or copy-and-paste in our workflows. Noone will go and manually type from what you have in your screenshot into a table.
Hi, Bruno. Thank you for your response.
I am dealing with dynamic columns. So for today, I’ll be dealing with Dec 2021 until Dec 2022.
It will always be 13 months, located in the same position (column).
The data is driven from Excel files - Previous data is fed thru Excel file, current month is added in the previous data. For example, Previous data in the excel file contains Dec 2021 to Oct 2022. Nov 2021 will be joined with this excel file thru KNIME.
Afterwards, I’d need to get the MoM difference as above.
Attached is the sample data, with the highlighted cells as the MoM difference. Book2.xlsx (14.4 KB)