lchester lchester - 4 months ago 99
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


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