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.
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.
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 |