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.