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

Kenda

@shivraj_r Looking at this again, I realize I had a brain fart yesterday.. What if you just try adding a Summarize tool after your input without the Unique tool? GroupBy your Old and New fields then add a Count as well.

That's the awesome thing about Alteryx - so many ways to get to the same result!