Count set of unique pairs

[shivraj_r]

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

[shivraj_r]

@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! :)