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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Counting value occurrences across multiple dynamic columns

Highlighted

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