Creating a Point System

[Alteryxuserhere]

Hii there

Basically I want to assign points for each field that is the same based on the following criteria

If same name then assign 70 points
Same product 30 points
same Channel 30 points
same country 2 points
same city 2 points
same post code 2 points

and then join all together to see how much points each person with the same ID has

Can someone suggest how I may be able to do this with the following data

ID	Name	Product	Channel	Country	City	Postcode
1234	James Smith	Handbag	Online	New Zealand	City 1	123465
1234	James Smith	Tote	Offline	Australia	City 1	123465
54232	Hange Doh	Purse	Online	Spain	City 4	1235657
142124	Tina Loue	Wallet	Online	Spain	City 5	64893
54232	Hange Doh	Purse	Online	Spain	City 4	142124

Thanks!

[geraldo · Accepted solution]

@Alteryxuserhere 

Below is an example workflow

[Alteryxuserhere]

Amazing thanks @geraldo  Can you explain why we need to group by ID and count ID in the beginning? Can't we do it after the transpose?

[geraldo]

@Alteryxuserhere 

Can be applied after transpose. I even added the filter tool to test it.