This post has a simpler approach to pivoting without aggregation using “ungroup” after the pivoting node as well. It also pointed out that you don’t need to select any GroupBy columns in the pivot node (you can just ignore the warning) which was an important piece to the puzzle.
Thank you for your reply - I really do not know how the pivot works and it looks like the two post you replied with are doing what I would like in reverse. I really would not know how to loop while using the pivot node.
The “unpivot” node does the pivoting action in reverse. Unfortunately it would be a few days until I could mock something up for you since I am on the road. Hopefully someone else can put together a quick workflow solution for you in the mean time. If not, I will build you one when I am back in the office next week.
Here is an alternate approach that gets to the same solution by looping the “paired columns” through Transpose in a series. Gets to the same place, but in a different order since it processes down columns instead of across rows.
Not that you need another solution, but I found this approach intriguing as my brain immediately thought of looping through the column pairs that were clustered by relationship and had never tackled it. Always more than one way to get there in KNIME!