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.
hi Cmcclellan thanks for your advice. everything seems to be working perfectly, but when I did a total count, i noticed that the total count after I did a union was greater than my original count. wondering why is that so?
Here's the thing about a join, for every join key match in the L & R inputs you get the product of L times R records on output. Whatever your join key is in the vlookup, if you put a UNIQUE tool after your WIP consolidated 4th July.xlsx with that key checked for duplicates, you will find that the count is now 4,232.
The vlookup finds the 1st occurrence of the lookup value if multiple are found. The UNIQUE tool outputs the first occurrence as well. If there is a preferred record to match, you should SORT the data prior to the UNIQUE tool to put that record first.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.