Darshan Hiranandani : How do I set up a dynamic transpose of columns to rows in my data?

[darshanhiranandani]

Hi Team,

I’m working on a workflow in Alteryx where I need to dynamically transpose columns to rows. My dataset has a fixed number of rows (35), but the number of columns (N) can vary. I’m aiming to convert the data so that it transforms from 35 rows and N columns into N rows and 35 columns.

Here are the key details:

• Current Format: 35 rows x N columns
• Desired Format: N rows x 35 columns

Given that the number of columns (N) is variable, I need a solution that dynamically adjusts to handle this change.

Could anyone provide suggestions on how to achieve this within Alteryx? Specifically:

1. What tools or combination of tools in Alteryx would be best for dynamically transposing columns into rows?
2. Are there any best practices or tips for ensuring the transposition works smoothly with varying column counts?
3. How would you handle potential challenges related to data integrity or formatting during this process?

Regards

Darshan Hiranandani

[OTrieger]

@darshanhiranandani 
Transpose should be able to deal with new columns, just keep Dynamic Unknown Columns Ticked