Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Counting value occurrences across multiple dynamic columns

Hi All,


Appreciate any assistance in advanced.


I am trying to determine how to count the number of times a name occurs across multiple columns. The columns will differ in length which will change over time. In my excel example below you will see that there are names in columns A B C and the count column has two names. What I would like to do is count the number of times each name in the count column occurs in columns A B or C.

So in this case, would like a 2 for Mike and 1 for John.


I assume there is some sort of function that could be put in the formula tool but I can't seem to find a viable solution.





Transpose tool will solve this. Let me spin up an example.


Edit: I've attached the workflow.


Much appreciated!