Extract Diagonal Matrix in Alteryx

[fsarmien]

How can I extract one diagonal from it and put it in a column? Please refer to the pictures below

Thank you so much for helping me out

[RolandSchubert]

Hi @fsarmien ,

maybe there is an easier way, but the first solution that came to my mind is to add a row number using the Record Id tool, transpose data using the Transpose tool, add column numbers using a Multi-Row Formula tool and select the cells with "Row" = "Column":

What do you think?

Best,

Roland

[atcodedog05 · Accepted solution]

Hi @fsarmien 

Here is my take on this

Workflow:

1. Using record id to set row id.

2. Using transpose tool to convert data columns to rows.

3. Using filter tool to keep only diagonal elements.

Hope this helps : )

[fsarmien]

Thank you so much for your help! Great community 

[atcodedog05]

Happy to help : ) @fsarmien 

Cheers and have a nice day!