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.
Thanks for this, currently not on my work laptop so no access to check this all until tomorrow. Quick question however, my data has a lot more columns would this still work? If I did a join in the same way with ID and Parent ID? For example additional columns are Name, Phone Number and Address. Would this change anything?
The key principle is to isolate the 2 things you want to compare to each other. You can then use a join or find replace as @BenMoss suggested to find matches for any of the fields you want to compare.
So you might end up with multiple sets of data based on the fields you picked to compare. If it's important to put it all back together to make it resemble your original dataset, you could add a record ID right at the start and then use this to join all your data streams together again at the end with a join multiple tool.