Grouping by multiple columns and listing differences

The1804

Hi,

I am brand new to Alteryx so this question might be on the easier side however I was not able to find similar topic in Alteryx Community.

My workflow needs to

1. List all combinations of first 2 columns as unique records

2. Count occurrences of each unique record

3. List all values from 3rd column (that have first 2 columns in common) separated by comma 

Any help would be highly appreciated.

Sample Input:

Num	Animal	Country
10100	Cat	MY
10100	Cat	TW
10100	Cat	CH
10100	Dog	CY
10100	Dog	CZ
10300	Turtle	MY
10300	Turtle	TW
10300	Turtle	CZ
10400	Turtle	QA
10400	Turtle	MY

Expected Output

Num	Animal	Count	Country
10100	Cat	3	MY, TW, CH
10100	Dog	2	CY, CZ
10300	Turtle	3	MY, TW, CZ
10400	Turtle	2	QA, MY

Jonathan-Sherman

Hi @The1804,

I think this is what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200519 - SummariseTable.yxmd