Count If

[Jaganmohan]

Hi,

Need your Support!

I need to implement below logic in Alteryx, can some one help me on this - Thanks.

Please Find attached below mentioned spread sheet : Need to implement D column Logic in alteryx. 

=COUNTIFS(B:B,"yes",C:C,C2,A:A,"<>0")

[AngelosPachis]

Hi @Jaganmohan,

You will have to filter out 0s from the first column and make sure that the values in the second column are "yes". Then you can count with a summarise tool and join back to your main table

[binuacs]

@Jaganmohan another option

[Jaganmohan]

Hi Angelospachis - Thanks a lot  and thanks for the quick response.

I have an additional question on the same logic, need to implement the below logic on the alteryx workflow.

=IFERROR(VLOOKUP(E2,Mapping!A:B,2,FALSE),"No")

Column F logic with mapping file (please find the attachment) - Thanks in Advance.

[AngelosPachis]

Hi @Jaganmohan ,

It's best practice to create a new post for this question since it doesn't relate to the topic of this thread anymore (CountIf) and if you can't find the answer to your question in another post in the community.

From a quick google search of the terms "if error vlookup alteryx", I came across three posts all of which are marked as solved; one of them might answer your question.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-can-I-transform-this-IFERROR-VLOOK...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/I-need-Help-to-Automate-this-IFERROR-V...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/IFERROR-VLOOKUP-A2-Act-A-I-9-FALSE-VLO...

Thanks,

Angelos

[Jaganmohan]

Thank you.