Data preparation (unpivot?)

Dear experts,

How would you change from a pivoted table to a narrow and tall table? I have uploaded the data transformation need. Resolved incident is the pivoted form and the “Ideal” tab is the result I want. I couldn’t figure it out with the unpivot node today. Thank you for the help.

data_prep_-_flights modified.xlsx (18.6 KB)

You’ve been on the right track! Give the Unpivoting node a try. Select the date columns as your value columns and add the employee column as retained column. This should give you the desired transformation.
For clarification I’ve added a workflow for you.

unpivot.knwf (3.4 KB)


Thank you Marten for the help. I am able to follow your example and make it work!

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