community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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.

 

Thanks!

 

Bolide
Bolide

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

 

Edit: I've attached the workflow.

image.pngInputimage.png

Much appreciated!

Labels