Column order of pivot table

KNIME Analytics Platform
1

I know that this has been already a topic but I couldn’t find an answer for my problem.
I need to pivot a table then I need to perform calculations on the pivoted columns, where the column order matters: I need to deduct the amount from of the current day from the amount of a previous day.
The values of the “Period” column will be dates of specific days. How do I know, which column to add to left and right side of the formula?
thank you
Pivot Column Order.knwf (13.0 KB)

2

I have found it, it is easy: pivoted columns are in alphabetical order.

2 Likes
3

Hey @HarryKl,

Great to hear you solved it and letting us know the result!

TL

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.