How to get count distinct across multiple columns for a row

[PPNU]

Hi,

I am pretty new to Alteryx . I am trying to get the count distinct in a separate column on the basis of values present in some of the columns in raw data.

For. eg. if media network  has any value which is unique with other media network columns then count increase else not.

so according to snippet I attached below , for row 53 count should be 2 and for row 52 , it should be zero.

There is no key column in raw data which can distinguish records uniquely.

Thanks in advance.

[Maskell_Rascal]

Hi @PPNU 

You can do this with the transpose and summarize tools. Attached is a sample workflow for you to try out. 

Cheers!

Phil