Countif Formula to Alteryx

[senzuki123]

Hi All,

I would like to have an workflow for this. Thanks in Advance

[senzuki123]

Need help for this. ASAP. Thanks in Advance

[bharti_dalal]

hi @senzuki123,

you can go to this link .

https://community.alteryx.com/t5/Data-Preparation-Blending/Equivalent-to-Excel-COUNTIF-function/td-p...

I hope that helps.

[senzuki123]

Hi @Bharti,

I want the same output aswell ? Will you recommend any links or workflow with same output

Thanks,

[bharti_dalal]

hi @senzuki123,

That link provide you the method of how to solve the problem. if you want exactly same what you need, please provide sample data sheet and i can give you solution. Thanks

[danrh · Accepted solution]

Hey @senzuki123,

In this kind of situation I usually suggest using a Summarize tool to aggregate the data (in this case, getting a count by RECORD ID), performing the calculation, and then using a Join to re-apply it to your dataset.  Something like:

Note that in the attached, I've added dummy data, rather than trying to replicate yours :)

Hope it helps!

[senzuki123]

Thank you so much @darnh,

[Phavaldar]

Thank you so much. You solution helped me to solve my problem. I am getting the result in a way i want. Thanks