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")
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
@Jaganmohan another option
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.