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 · Accepted solution]

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 😀👍

[atcodedog05 · Accepted solution]

Hi @lerben 

Here is a dynamic solution provided you have more categories.

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 😀👍

[lerben]

Thanks for the quick help, I have two problems. Somehow my strings are cut short. Second I obtain empty columns.... Thanks

[atcodedog05]

Hi @lerben 

In the attached workflow i am able to get expected output

Can you show me the error you facing?

[lerben]

Ok all good now 😉 just had to make the string longer and the columns actually were not empty 

[atcodedog05]

That happens 😅 

Happy to help 🙂 @lerben 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂