Hi all,
I'm trying to count the number of times a unique pair occurs in my dataset and wondering how to do this in Alteryx? I've used the sumproduct function on Excel and works fine. Attaching a sample here
Old | New | Count of unique pairs (output) |
a | b | 2 |
b | d | 1 |
d | g | 1 |
g | a | 1 |
a | b | |
b | a | 2 |
a | g | 1 |
g | b | 1 |
b | a |
Solved! Go to Solution.
@Kenda Thanks for the solution! I poked around last night and kinda figured I could do that! You're right so many ways to get to the same result! :)
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |