The Alteryx Transpose tool has a feature where you could select a Key Column see example below and it would then transpose the rest of the data columns with the Key Column/columns repeated where they were associated with those rows.
The Transpose Table node does not have this option and I am struggling with how to replicate this output. Any suggestions? A search in the forums didn’t turn up anything.
For those without Alteryx experience this is what Key Column does:
[In Alteryx Transpose tool, Key Columns are used to select the columns to pivot the table around, while Data Columns are used to configure which rows to split them into]
Should I actually be using the Pivot Node instead and configuring it a specific way?
