countif

Question

I have a table pulled into Alteryx similar to the one below called the Alteryx Table. I am looking to do a count for each ID for every string in F.Name to result in a count as shown below:

Result:

ID                                    Code                             Corp                             F.Name

19C:7782260-1:V1    7782260-1    Waterfall                         7

Alteryx Table:

ID                                    Code                             Corp                             F.Name

19C:7782260-1:V1    7782260-1    Waterfall                         Inc.                       19C:7782260-1:V1    7782260-1    Waterfall                                  Inc.             19C:7782260-1:V1    7782260-1    Waterfall                                   QUALITY               19C:7782260-1:V1    7782260-1    Waterfall                                  QMC MIDCO             19C:7782260-1:V1    7782260-1    Waterfall                                EMI MidCo        19C:7782260-1:V1    7782260-1    Waterfall                                QMC Holdings   19C:7782260-1:V1    7782260-1    Waterfall                                QMC-EMI19C:7782260-2:V1    7782260-2    Waterfall

Although all the IDs are the same there is no string in the last row so that would not be counted therefore resulting in a count of 7. In Excel I was using the Countif function, but I can't seem to figure out how to apply that same logic in Alteryx using the formula tool.

mceleavey · Answer

@kthakk7 ,

I've applied that change for you.

M.

EXAMPLE_mceleavey.yxmd

kthakk7 · Answer

I realized I mistyped above. The second ID since it is unique from the first we wouldn't want to eliminate that row of data but instead see a 0

Result:

ID                                    Code                             Corp                  F.Name

19C:7782260-1:V1    7782260-1    Waterfall                         719C:7782260-2:V1 7782260-1    Waterfall                         0

mceleavey · Answer

Hi @kthakk7 ,

This is achieved by grouping in the Sum tool and removing those rows that have no F.Name value:

Hope this helps,

M.

EXAMPLE_mceleavey.yxmd