countif

[kthakk7]

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-EMI
19C: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]

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.

[kthakk7]

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	7
19C:7782260-2:V1	7782260-1	Waterfall	0

[mceleavey]

@kthakk7 ,

I've applied that change for you.

M.