Column headers to row values
Hello partners!! : D
Today I’m facing a new challenge in a knime workflow :muscle::smirk_cat:.
So, I was wondering if there is a way to convert column headers into values. Let me show you the table I have:
And the output I´m trying to get should be something like this:
OR
I need to sort those column headers as values, to find a time difference once it´s ordenated
The things I´ve tried are
Unpivot
Column agregation + ungroup
List column group + date & time difference
Some of this solutions lose data, create “duplicates” or simply didn’t work
I ran out of ideas, so I´ll be very happy with any new idea or help to this.
BR
-N