lchester lchester - 1 year ago 245
R Question

Finding unique combinations based only on one of the columns using Alteryx

I have the follow sample of a large dataset:

enter image description here

I am trying to establish which of the colours are exclusive to the packs, as it should show on the exclusive colour column.
I am using Alteryx, but can also be R.

I wonder how can I assess if the colour on the second column is exclusive to the pack on the first column

Answer Source

For an Alteryx solution: Summarize counting distinct pack per color; a distinct pack count greater than 1 for any colour basically means FALSE for your desired column. Therefore: Summary Tool, Formula Tool, and Join back to your original data. (see screenshot). enter image description here

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download