Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

how to do count if function

christof
5 - Atom

Hi there,

 

I wanted add a column to show how many times a certain value (in a row) appear in a column? just like a COUNT IF function in excel.

 

thank you in advance

 

 

 

 

5 REPLIES 5
Inactive User
Not applicable

IF Contains([Column],'Value') THEN 1 ELSE 0 END

christof
5 - Atom

Thanks Ryan.

 

is there a way to count how many times a value (Each Value) appears in Column A?

ramatp30
7 - Meteor

HI @christof

 

Is it something your looking for like attached one?

ponraj
13 - Pulsar

Here is the sample workflow for your case. Hope this is helpful. 

 

WorkflowWorkflowResultsResults

christof
5 - Atom

This is Great! Thank you ponraj. Appreciate your help

Labels