Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
GELÖST

how to do count if function

christof
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 ANTWORTEN 5
Inactive User
Nicht anwendbar

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

christof
Atom

Thanks Ryan.

 

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

ramatp30
Meteor

HI @christof

 

Is it something your looking for like attached one?

ponraj
Pulsar

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

 

WorkflowWorkflowResultsResults

christof
Atom

This is Great! Thank you ponraj. Appreciate your help

Beschriftungen