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.
Have commonly seen this done by bringing in the last-month's Excel sheet and doing a Join with the new information. Anything that is found in both will come out the 'J' anchor, while your unmatched records from the 'L' or the 'R' (depending on which side the new data is on) will just be the new numbers that you can output.
Similarly, could union the two months together and use the Unique tool on number.
Yes, you can do this by comparing the October data (let's say) to the November data. Whatever doesn't join from the November side is your list of new data. You can then append that to the October data.