COUNTIFS in Alteryx Designer

Question

Hi All,

I have the following table:

IDTYPEVALUEID1T1 ID1T2X1ID1T3 ID1T4 ID2T1 ID2T2 ID2T3Y2ID2T4 ID3T1X4ID3T2Z6ID3T3 ID3T4

I now want a new field, let's call it COUNT, that for each ID counts how many cells in column VALUE are blank for TYPE is T1 or T2. So I want to end up with a table like below.

IDTYPEVALUECOUNTID1T1 1ID1T2X11ID1T3 1ID1T4 1ID2T1 2ID2T2 2ID2T3Y22ID2T4 2ID3T1X40ID3T2Z60ID3T3 0ID3T4 0

How would I do this? Thanks for your help.

CoG · Answer

We can even simplify even further (at times) with the Formula Tool:

Sample Workflow.yxmd

Qiu · Answer

@RVDL 
It is hard to say there is a specific workflow of pattern for CountIf function in Excel but usually it will involve Filter tool as "If" and Summarize tool as "Count".

For your case, we can do as below.

1204-RVDL.yxmd