Find Distinct Count

[learnalteryx]

Hi  Can you please help me find the Distinct Count ?

Original Data Set is below  . Please note there are more columns, I have put till  Column5 just for this example

Load Country	Discharge Country	Column1	Column2	Column3	Column4	Column5
ALGERIA	QATAR	1	2
ALGERIA	QATAR	2	1	1	3
ALGERIA	PERU	4	5	6	4
ARGENTINA	PERU	5	5	7	9
ARGENTINA	ECUADOR	2	2	2	7

This is the output that I want, Load Country and Discharge Country should be grouped together see below and I need to find the Distinct Count of the numbers inside the columns

Load Country	Discharge Country	Column1	Column2	Column3	Column4		Distinct Count
ALGERIA	QATAR	1	2	3			3
ALGERIA	PERU	4	5	6			3
ARGENTINA	PERU	5	7	9			3
ARGENTINA	ECUADOR	2	7				2

How can I find the Distinct Count 

Thank you

[Luke_C]

Hi @learnalteryx 

Here's one way, it should be scalable to more columns: