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