Hi,
I believe, an Unpivot followed by a Date Extract and then a Pivot should efficiently handle this. If you’re working with multiple date columns, this approach will be especially useful.
For your convenience, I’ve uploaded a sample dataset and the corresponding KNIME workflow. Hope this helps!
Let me know if you have any questions.
Best,
Alpay
KNIME_Project_ExtractTimefrommultipledatetimecolumnswithonenode.knwf (19.2 KB)
CP.xlsx (4.8 KB)