Using Unique tool to find overlap between seasons

Hi All,

Wondering if anyone can help. I have 3 data sets, all which have combinations of type of material ordered. I need to find whether or not the same materials have been ordered across different seasons. I can see it is the case, but I want to provide a table of overlap, whereby it states the season where it was ordered.

Can anyone suggest anything?

Data Investigation

Accepted answers

NickSm

Hey @swilson9 ,

Think you're on the right track with the Unique tool to create that duplicate table - only problem with the out-of-the-box Unique tool is that it keeps the first unique record in your "U" output. Luckily there's a tool developed by a partner called Only Unique, which will only output truly unique records through the "U", meaning the "D" output sounds like it should be the table you're looking for after you bring those 3 sources together in a join or union.

It's part of the CReW macro pack - can check out the tool and download it here. Bunch of other cool functionality in the download as well.

http://www.chaosreignswithin.com/2014/08/only-unique-macro.html

Feel free to post a sample of the data if you have some more questions.

All comments

NickSm

Hey @swilson9 ,

It's part of the CReW macro pack - can check out the tool and download it here. Bunch of other cool functionality in the download as well.

http://www.chaosreignswithin.com/2014/08/only-unique-macro.html

Feel free to post a sample of the data if you have some more questions.

swilson9

So now I have been able to find the fully unique seasons, I want to know what the percentage of total records is. Does anyone know how to work this out?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

hhaigh1 280