How to extract column headers from a matrix

lerben

HI all, 

I have following problem: I have a matrix that contains 0 and values, for each row I would like to order the column headers in order of these values e.g. 

Input     

	A	B	C	D
X	0	5	3	0
Y	0	0	0	2

Output

	Category 1	Category 2	Frequency 1	Frequency 2
X	B	C	5	3
Y	D		2

How can I achieve this in Alteryx?

Thanks for your help,

-L

atcodedog05

Hi @lerben 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

matrix.yxmd