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.
Having had to solve this problem before, there is no other way I would solve it but to use the Make Group tool. If I had to navigate an ID history table and understand how ID's merge and shift over time, I would only solve it with Alteryx:
Given an ID, you don't know if it is OLD or NEW can you merge the result to find the most newest form of the ID?
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Love it...it's true you are just saying what everyone else was thinking!!! We all only really do all the business stuff with Alteryx to tick the "business case" box, when we all know what it's really for!! 😄
Second that! Data blending is the ONE AND ONLY critical requirement. Working in a company built from multiple M&A really needs a good data blending application to "glue together" those desperate data sources!