This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.