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.
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.